CODEWITHSUNDEEP
ssisscd
user998918
user998918

Reputation: 21

Slowly changing dimension type 2 implementation in SSIS

what is the best way to implement the type 2 dimension in SSIS from the following options:

1.using merge statement. 2.using SSIS SCD component 3.using lookup, conditional split(custom way to implement it).

could you please give me the detail on it how to implement all of these and pros and cons of each.

thanks in advance. Zaim raza.

Upvotes: 1

Views: 1604

Answers (1)

billinkc
billinkc

Reputation: 61201

4) Dimension Merge SCD

Even if you don't go with that component, watch the 6 part videos linked from that page and see which one works best for your workload and skill-set.

Upvotes: 1

Related Questions