Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - What is update override. Difference between SQL override and update override?




2318
views
asked marvit September 20, 2014 08:05 AM  

What is update override. Difference between SQL override and update override?


           

1 Answers



 
answered By Mswami   0  
Update Override:

- An option of TARGET instance
- The Target table is updated based on Primary Key values.
- To update the target table on non-primary key, default query need to be generated.
- The Query should override as per the requirement by including a condition in where clause of the default query

SQL Override:

- An option available in Source Qualifier and Lookup Transformation
- Joins, Filters and Group By and Order By clauses are included to override

By Default the integration service updates the target based on key columns. But we might want to update non-key columns also, at that point of time we can override the UPDATE statement for each target in the mapping. The target override affects only when the source rows are marked as update by an update strategy in the mapping.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert