Interview incremental action plan

Return customer_id and load_action after deduping staged customer rows and comparing to the current dimension.

Start by naming the output grain, then build CTEs that can be inspected one at a time.

Sample input

customer_stage vs dim_customer_currentDedupe staged rows, ignore null keys, then compare source to target.

customer_id	stage_tier	target_tier	is_deleted
101	gold	silver	0
103	bronze	bronze	1
104	platinum	gold	0
105	bronze	bronze	0

Expected output

Expected outputUse delete, not delete_candidate, because this capstone asks for final action labels.

Constraints

State the output contract first, use readable CTE layers, return the exact columns requested by the prompt, and use deterministic ordering.

Expected skills

Interview clarification, SQL structure, edge-case handling, and final-answer narration.

SQL

AI evaluation

Run the SQL query to inspect preview rows.