medium10 pts · first answer countsdata-modellinglate-arriving-data

Fact arrives before its customer

A sales row arrives with customer_id C981, but the customer record will only land in tomorrow's load. What is a common way to load the fact today?

A.Drop the sale and wait for it to be resentB.Load the fact with a NULL customer key foreverC.Delay the entire sales load by one dayD.Insert a placeholder customer row and fill it in later

Discussion 0

Join free to post in the discussion.

Fact arrives before its customer

Discussion 0

Related questions