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
condition.
Correct me If I'm wrong
Thanks
Moorthy

Is This Answer Correct ?    2 Yes 0 No

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

Answer / ankur saini er.ankur861@gmail.

Hi

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  






Categories