what is target update override and when we use it?
Answers were Sorted based on User's Feedback
Answer / moorthy g
Whenever the source table have non key columns but I want to
update in the target table then you have to go for target
Target Properties - Update Override - give some update
Correct me If I'm wrong
|Is This Answer Correct ?||2 Yes||0 No|
Answer / ankur saini er.ankur861@gmail.
Even if the table has key columns but as per some
requirement you dont want to update the records based on
that key column in this scnario also we can use update
overide to update the records based on our desired column
(s) other than primary index(td) or primary key(oracle)
|Is This Answer Correct ?||0 Yes||0 No|
Define mapping and session?
what is difference between COM & DCOM?
What are the uses of etl tools?
What is a shortcut and copy in Informatica and how two are different with each other?
Enlist few areas or real-time situations where informatica is required.
How will u pas the data with out debugger?
How to convert multiple rows to single row (multiple columns) in informatica
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.
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
how u know when to use a static cache and dynamic cache in lookup transformation.
Global and Local shortcuts. Advantages.