Figure 3-316 STORE_ID 33 sales transactions 2/2
Seven of these sales transactions were deliberately tailored to create the following error conditions, which result in all these transactions being written to a reject file corresponding to late arriving dimensions, since no matching business keys are found (for these records) in the appropriate dimension tables:
STORE_ID of 9 and 99 do not exist in the Store dimension table.- CUSTOMER_ID of 5 does ...
Get IBM InfoSphere DataStage Data Flow and Job Design now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
