Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, September 12, 2014 4:50 AM
Points: 78, Visits: 448
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