Which step defines how data will be transformed during migration?

• A. Define data mappings
• B. Data profiling
• C. Cutover planning
• D. Reconciliation

Answer: (A)

Defining how data will be transformed is captured in data mappings, which lay out how each source field relates to a destination field and what changes to apply to the values during migration. This is where transformation rules are specified—such as converting date formats, changing data types, trimming or padding text, deriving new values, or combining and splitting fields—so the ETL process knows exactly how to convert and place data in the target system. Data profiling looks at data quality and structure before migration to anticipate issues, cutover planning handles going live, and reconciliation verifies accuracy after the move.