MDWT_2008 Question

View previous topic View next topic Go down

MDWT_2008 Question

Post  moreno on 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

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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