Hi,
I think slowly changing dimension object is not a good choice to update my dimension. It's running slower than I expected. my dimension records has surrogate keys from a control table that SCD is looking up whenever it encounters a new record.
Any alternative I can use?
cherriesh wrote:
Hi,
I think slowly changing dimension object is not a good choice to update my dimension. It's running slower than I expected. my dimension records has surrogate keys from a control table that SCD is looking up whenever it encounters a new record.
Any alternative I can use?
Most people use the techniques described here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1211340&SiteID=1
-Jamie
|||Hi Jamie,
I tried to use your example with the lookup to check if record is existing or not. If the record is already existing and has changed, then that means that I have to use the oledb command to update my table? based on the forums i read, this object runs slow. do i have any alternative for this?
http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx
cherriesh|||See my blog...
there is a post to populate dimensions... different from others...
Regards!
|||Hi Pedro,
Which one in your blog? can you post the url.
thanks a lot!
cherriesh
|||
cherriesh wrote:
Hi Jamie,
I tried to use your example with the lookup to check if record is existing or not. If the record is already existing and has changed, then that means that I have to use the oledb command to update my table? based on the forums i read, this object runs slow. do i have any alternative for this?
http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx
cherriesh
Cherriesh,
As part of the thread that Jamie posted earlier, there is a discussion on alternatives -- namely loading your updates to a staging table that you later use an Execute SQL task to perform the batch update. Please read through that entire thread.
|||http://pedrocgd.blogspot.com/2007/05/ssis-populating-dimension_28.html
Helped?
Regards
|||your problem is resolved?!
No comments:
Post a Comment