STEP 03 / 06
Step 03: Development and Build - Details
Implement the extraction, transformation, loading, and validation processes and prepare the migration environment.
02
Details: Work and outputs
The work shown in the overview is made concrete through inputs, outputs, dependencies, and completion conditions.
1. Output purpose and completion
| Output | Purpose | Completion and next use |
|---|---|---|
| Migration execution environment | Provides reviewed evidence for the development and build stage. | Approved, stored, and ready for the next stage. |
| Migration programs and scripts | Provides reviewed evidence for the development and build stage. | Approved, stored, and ready for the next stage. |
| Data reconciliation program | Provides reviewed evidence for the development and build stage. | Approved, stored, and ready for the next stage. |
| Migration job flow | Provides reviewed evidence for the development and build stage. | Approved, stored, and ready for the next stage. |
2. Work, inputs, outputs, and dependencies
| Work | Summary | Input | Output | Dependency | Class |
|---|---|---|---|---|---|
| Build the migration environment | Execute and review the activity using the approved controls. | Approved prior-stage information | Reviewed stage evidence | Prior step | Required |
| Implement ETL and migration processing | Execute and review the activity using the approved controls. | Approved prior-stage information | Reviewed stage evidence | Build the migration environment | Required |
| Implement reconciliation | Execute and review the activity using the approved controls. | Approved prior-stage information | Reviewed stage evidence | Implement ETL and migration processing | Required |
| Automate migration jobs | Execute and review the activity using the approved controls. | Approved prior-stage information | Reviewed stage evidence | Implement reconciliation | Optional |
3. Supporting documents and tools
Supporting documents
Use this category to support review, execution, and traceability.
Candidate tools
Use this category to support review, execution, and traceability.
Automation and quality controls
Use this category to support review, execution, and traceability.
4. Change and history management
Version-control definitions, execution logs, approvals, and exceptions. Record the reason, owner, approver, timestamp, and affected scope for every material change.
5. Completion condition
The migration programs, environment, monitoring, logs, and rerun procedures have been built and reviewed.