CIS Data Migration & Integration Flashcards

What is the primary goal of an ETL process in a CIS data migration?

Answer: Extract, Transform, and Load data from source to target systems

ETL (Extract, Transform, Load) is the process of pulling data from source systems, converting it to fit the target format, and loading it into the destination system.

During CIS data migration planning, a data profiling exercise is conducted to:

Answer: Assess the quality, completeness, and structure of source data

Data profiling analyzes source data to understand its quality, completeness, and structure before mapping it to the target system.

Which type of integration connects two systems in real time so that data changes in one system are immediately reflected in the other?

Answer: Real-time or event-driven integration

Real-time or event-driven integration propagates data changes immediately between systems, often using APIs or message queues.

A data mapping document in a CIS migration project defines:

Answer: The correspondence between source fields and target fields

A data mapping document specifies how each field from the source system corresponds to fields in the target system, including any transformation rules.

What is a 'cutover plan' in the context of CIS data migration?

Answer: A detailed sequence of steps to switch from the old system to the new system

A cutover plan documents the precise sequence of activities, responsibilities, and timing required to transition from the legacy system to the new one.

Which migration strategy involves running old and new systems simultaneously for a period to validate the new system before fully decommissioning the old one?

Answer: Parallel run migration

A parallel run keeps both systems active simultaneously, allowing comparison of outputs and reducing risk before committing fully to the new system.