Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Loading accumulating snapshot fact table Expand / Collapse
Posted Tuesday, August 19, 2014 8:26 AM


Group: General Forum Members
Last Login: 2 days ago @ 4:45 AM
Points: 151, Visits: 696
Im having a bit of trouble getting my head round this one. I understand what these are and i am trying to utilize this type of fact table to cover our purchase order status flow.

Im tyring to build the ETL for this from scratch (cant find any examples of etl for thisonline) and getting confused. Am i right in thinking the first thing i need to do is check that each record from my source is not already in the fact table, this will tell me if this is an Update or insert.

i this is correct then how do you do the lockup? the target fact table only has the surrogate keys where as the source table has the natural keys?

any help welcome.
Post #1604954
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse