Hi

Thanks for the reply. When i say creating etl packages im really talking about complex ones with lookups, conditional splits derived colums inserts and updates etc. This business process im talking about is just one of a few processes, the rest of which properly use etl and staging tables for the exact reasons you mention i.e. load and scd.

Im new to DW so im just not sure if you have to create complex etl package and analyse scd's requierments on all data needed. or is it sufficient to just have an etl that drops and recreates the data in some dimensions for example for an appointment status dimension that only has 10 rows do you really need to create a complex package that track type 1 & 2 changes?