What are the differences between sql override and update override?
- 1 Answers
- 1183 Views
- I also Faced
- E-Mail Answers
Answer Posted / Rinki
SQL Override and Update Override are both techniques used in ETL processes to handle data conflicts, but they operate slightly differently:n
1. SQL Override: In this method, a SQL statement is executed before or after the data integration process to resolve conflicts between source and target systems. The SQL statement can be used to update, delete, or insert rows as needed.
2. Update Override: Unlike SQL Override, Update Override performs updates directly on the target system without involving a SQL statement. This method replaces existing data in the target system with the updated data from the source system if there is a conflict.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the data modeling tools you have used?(polaris)
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
