How can I update records in the destination table. Like how can I specify that......if the record doesn't exists then insert it.....or if the record is updated then update it (based on some field)......This functionality is available in Informatica and IBI
Amarpreet wrote:
How can I update records in the destination table. Like how can I specify that......if the record doesn't exists then insert it.....or if the record is updated then update it (based on some field)......This functionality is available in Informatica and IBI
You need to split the data flow into records that need updating and records to be inserted. There are 2 methods of doing this as described here: http://www.sqlis.com/default.aspx?311
If you want more detail on SSIS -v- Informatica then look here: http://www.microsoft.com/sql/integration/Conchango.mspx
-Jamie
