What are the differences between sql override and update override?
- 1 Answers
- 1186 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Can we create Hierarchies in generic datasources?
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.
What is meant by incremental load?
What is Relational Integrity?
what is pmrep command?
what are the data modeling tools you have used?(polaris)
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
flat filevalidation in informatica
what make u disappointmnets in u r career
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?
1 Answers IBM, Saama Tech, Wipro,
we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??
Teradata 
