Implementaion for fact table with 15 foreign keys

Topics: Issues 3: Executing the Component (Run-Time), Possible Bugs/Missing Features?
Aug 10, 2012 at 12:30 PM

I have used this component for dimensions and facts.

For Dimensions it is working as expected and I have set the primary key as business key.

But for Fact table, the source is having 323 rows and existing dimension has 0 rows. The new output is having only 106 rows.  Update SCD1 has 0 rows. I have set all the foreign keys as business keys. Could you please let me know if I its right ?

Note: I am using only two outputs new and updated SCD1. 

The number of rows in fact tables are less than 1000.

Thanks in advance..

Aug 21, 2012 at 10:50 AM

um think your getting mixed up there. You don't usually use the SCD component on Fact tables. Process your dimensions with the SCD component. Then your fact table load should only use lookups on the business keys (and date) to the dimensions.