O'Reilly logo

IBM InfoSphere DataStage Data Flow and Job Design by Denis Vasconcelos, Sachiko Toratani, Celso Takahashi, Nagraj Alur

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Image

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:

  • Image STORE_ID of 9 and 99 do not exist in the Store dimension table.

  • Image CUSTOMER_ID of 5 does ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required