CODEWITHSUNDEEP
pentahodata-warehouse
Karthi
Karthi

Reputation: 708

Loading fact table with SCD type 2 dimension

I have got a dimension tables with 1 million records which is SCD type 2.I am using pentaho Dimension lookup step for populating this dimension table. I am getting a version number,start date and end date. Now I want to populate the fact table based on the scd type2. What is the best approach for this?

Upvotes: 1

Views: 1056

Answers (1)

matthiash
matthiash

Reputation: 3233

Use the 'Dimension lookup/update' step for looking up the surrogate id ('Technical key field'), based on the natural key(s) ('Keys') and timestamp ('Stream Datefield'). Uncheck 'Update the dimension' if you only do lookup.

Upvotes: 2

Related Questions