Explain the ETL process.
Use the provided staging and reference tables to demonstrate extraction, transformation, validation, and preparation of load-ready rows. Include records marked READY, preserve data-quality issues with an explanatory status, and exclude records that are not ready.
sale_id, customer_name, sale_date, amount, sale_month, and quality_status.sale_date, then sale_id.| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Source sale identifier |
| customer_id | VARCHAR(10) | Source customer identifier |
| sale_date | DATE | Date associated with the sale |
| amount_text | VARCHAR(30) | Sale amount received as text |
| source_status | VARCHAR(20) | Source processing status |
| Column | Type | Description |
|---|---|---|
| customer_idPK | VARCHAR(10) | Reference customer identifier |
| customer_name | VARCHAR(100) | Reference customer name |
| customer_segment | VARCHAR(30) | Customer classification |