1. Choose ETL or ELT from the workload
TASK: Draw an ETL and an ELT version of the same workflow. State where source validation and business transformations occur.
Your method:
Your evidence/result:
Limitations and next action:


2. Implement ingestion, transformation and validation
TASK: Run the local pipeline and inspect prepared.json, rejects.json and result.json. Identify valid cancelled lines versus rejected rows.
Your method:
Your evidence/result:
Limitations and next action:


3. Define publication and failure boundaries
TASK: Document a publication contract and test a duplicate order key in a separate copy. Explain what a partial output folder means.
Your method:
Your evidence/result:
Limitations and next action: