Loading a Fact Table - Best Practice Question

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  data warehouse design   » Loading a Fact Table - Best Practice Question

Loading a Fact Table - Best Practice Question

Topic RSS Feed

Posts under the topic: Loading a Fact Table - Best Practice Question

Posted: 8/28/2010

Jedi Youngling 98  points  Jedi Youngling
  • Joined on: 5/24/2010
  • Posts: 39

I have a DimProducts dimension which has a business (natural) key which consists of three columns. Facility, Part Number, and Part Revision. 

 

When I perform the lookup during the FactOrders ETL, I will need to check those three values in my staging table against them in DimProducts. If found, the surrogate key gets entered for that row in the fact table. If not, I add a record to DimProducts with basic information to be updated later and the new surrogate value is added to FactOrders. 

 

For practical purposes, do you guys ever create a single field in the Dimension which is a concatenation of the other three to make this process easier or perhaps faster? 


Posted: 8/30/2010

Jedi Youngling 98  points  Jedi Youngling
  • Joined on: 5/24/2010
  • Posts: 39

Nobody has any advice for me?


Page 1 of 1 (2 items)