|
|
|
Grasshopper
 
Group: General Forum Members
Last Login: Tuesday, March 02, 2010 1:40 PM
Points: 10,
Visits: 76
|
|
We have several ETL packages and it seems that the larger the destination table is, the longer it takes to open the Slowly Changing Dimension Task Wizard.
We are looking to change some of the attributes that are currently set to Historical, and opening the SCD Wizard takes anywhere from 30 seconds on a few hundred thousand rows to 5+ minutes for millions of rows in the destination table.
Has anyone else had any issues related to this and solutions?
Thanks
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Tuesday, March 02, 2010 1:40 PM
Points: 10,
Visits: 76
|
|
| Just found a way around by using the advanced editor but any other solution would be welcomed.
|
|
|
|
