Dimension loading with executing SQL tasks in SSIS for SCD type 1 and type 2

Gyanendra Jaiswal

Rate me:

4.95/5 (5 votes)

29 Sep 2013CPOL3 min read

31.7K

Dimension loading using SQL task gives better performance than SCD transformation.

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

No alternatives have been posted.

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Gyanendra Jaiswal

Web Developer

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.