what is target update override and when we use it?

Answers were Sorted based on User's Feedback

what is target update override and when we use it?..

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
update override.

Target Properties - Update Override - give some update
Correct me If I'm wrong

Is This Answer Correct ?    2 Yes 0 No

what is target update override and when we use it?..

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

Post New Answer

More Informatica Interview Questions

Define mapping and session?

0 Answers   Informatica,

what is difference between COM & DCOM?

1 Answers   Satyam,

What are the uses of etl tools?

0 Answers  

What is a shortcut and copy in Informatica and how two are different with each other?

0 Answers  

Enlist few areas or real-time situations where informatica is required.

0 Answers  

How will u pas the data with out debugger?

4 Answers  

How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   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.

0 Answers   iGate,

How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  

how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers   Accenture,

Global and Local shortcuts. Advantages.

0 Answers