Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Kimball Forum

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


MDWT_2008 Question

Kimball Forum :: Topics :: ETL and Data Quality

Go down

MDWT_2008 Question Empty MDWT_2008 Question

Post  moreno Fri Sep 16, 2011 10:39 pm

I have sucessfully created a datawarehouse following the SSIS packages (MDWT2008_Extract and MDWT_2008) samples from the book.

I have also uploaded the packages to SQL and get them scheduled.

After completing my historical load one question came to my mind, what should I use for imcemental loads. Should I keep truncating and uploading everytime, or should I disable the execute sql task that truncates tables, will this create a Lookup issue with my fact table load, since I am using lookups.

Any Ideas?


moreno

Posts : 5
Join date : 2011-08-04

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: ETL and Data Quality

 
Permissions in this forum:
You cannot reply to topics in this forum