May 7, 2014 at 6:41 am
Got it. thanks again.
May 7, 2014 at 7:14 am
For the Merge Join, if I am using inner join, will there be an option to redirect records that do not match? This is very important for me because essentially the records that do not match would be considered new records for me.
May 7, 2014 at 7:24 am
That would be a left input join. (similar to a left outer join in TSQL)
You'll have to check for NULL values and use a conditional split.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 26, 2014 at 11:10 am
Not sure if this is still an issue for you... other options are using the fast load option in a OLE DB destination. Not sure if there are constraints on the table that need checking ..but indexing or rebuilding indexes on the reference columns can help. Also look into the rows per batch and the maximum insert commit size options in the OLE DB destination ( try starting at 10,000 for this one - how large the batch should be before issuing a commit).
----------------------------------------------------
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply