WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?
Answer Posted / ram reddy
Update Override it is an option available in TARGET
instance.By defalut Target table is updated based on
Primary key values.To update the Target table on non
primary key values u can generate the default Querey and
override the Querey according to the requiremnet.Suppose
for example u want to update the record in target table
When a column value='AAA' then u can include this condition
in where clause of default Querey.
Coming to SQL override it is an option available in Source
Qualifier and Lookup transafornmation where u can inlude
joins ,filters,Group by and order by.
Is This Answer Correct ? | 21 Yes | 0 No |
Post New Answer View All Answers
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
can we override a native sql query within informatica? How do we do it?
What is lookup transformation?
Can anyone tell me the new features in Informatica 9 Version?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is pmcmd command?
What is rank transformation in informatica
Why do you use Mapping Parameter and mapping variable?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is Session and Batches?
EXL informatica Questions
What are the designer tools for creating transformations?
define galaxy repository in informatica
What is the maplet?
Is stop and abort are same in informatica?