Please advise how to use a Lookup component in SSIS for SCD Type 1 change.
I am able to to insert and update changes to the target table making use of lookup
and conditional split.
However i am not sure how to delete a row in the target table
if that happens in source table.
Also is it necessary to have a surrogate key in my dimensions and facts and can that be an
also can i make use of multiple columns which are pk in my oltp tables as business key in olap tables.
Also is it necessary to have a start and end date column in each dim and fact table.