Practice Test Geeks(ERP) Enterprise Resource Planning Certified Practice Test
← All ERP Flashcard Decks

Data Cleansing & Migration Strategy Flashcards

7 cards from real ERP practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Data Cleansing & Migration Strategy flashcards as text

  1. In ERP migration, a 'golden record' is best defined as:

    Answer: The single authoritative master record created by merging and deduplicating source records

    A golden record consolidates the best, most accurate attributes from duplicate source records into one trusted master record for the ERP target system.

  2. Which strategy is most appropriate when legacy ERP data contains codes that have no direct equivalent in the new ERP system?

    Answer: Define a crosswalk (lookup) table that maps legacy codes to new system values during ETL

    A crosswalk table maps legacy codes to target equivalents during transformation, ensuring data is correctly converted without manual post-migration editing.

  3. What does 'data migration reconciliation' verify after loading data into the ERP target?

    Answer: That record counts and key financial totals match between source and target

    Reconciliation confirms that the number of migrated records and aggregate values (e.g., total AR balance) equal the source system figures, validating completeness and accuracy.

  4. Why is end-user involvement critical during the data cleansing phase of ERP migration?

    Answer: End users have domain knowledge to identify which dirty records are valid exceptions vs. true errors

    Business users understand data context and can distinguish between legitimate edge cases and genuine errors that automated rules might misclassify.

  5. Which migration pattern best suits an organization that cannot afford any system downtime during ERP cutover?

    Answer: Parallel run with phased cutover

    A parallel run keeps both old and new systems operating simultaneously, allowing a phased handover without a full outage window.

  6. Standardizing date formats across source systems before ERP migration is an example of which data quality activity?

    Answer: Data normalization

    Normalization restructures data into a consistent standard form, such as converting MM/DD/YYYY and DD-MON-YYYY to a single ISO 8601 format.

  7. A 'rollback plan' in ERP data migration is essential because:

    Answer: It provides a tested procedure to restore the source system if the go-live fails

    A rollback plan defines the steps to revert to the legacy system if critical failures occur during or immediately after go-live, minimizing business disruption.