May 24, 2012 at 8:35 am
I have table1 and table2.
Table1 is source table and table2 in Dim table. when i insert value, or update ant value or delete value it should effect to the dim table also....
If i insert record in source table then it will dynamically insert in dim. same as if any data updated or deleted in source table then it should change in dim table.
i need to create stored procedure or SSIS package for that.
Aapno khub khub aabhar ( In Gujarati Language - india )
( Thank you very very much )
May 24, 2012 at 8:40 am
the merge command will do what you need to do
when not matched by target = insert
when not matched by source = delete
when matched and target.col1 <> source.col1 or target.col2 <> source.col2 etc etc = update
May 24, 2012 at 8:49 am
Hi thanks for the reply.
yes you are right i need to use merge... i dont know how to perform that task..
May 24, 2012 at 8:53 am
lookup the merge syntax in BOL or Google, its basically a fancy update/insert/delete combine statement, based on what you want, the main bits are the WHEN MATCHED and WHEN NOT MATCHED which I have already detailed.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply