1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

what is target update override and when we use it?

Question Posted / mehul.thakur

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

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  

Explain constraint based loading in informatica

0 Answers   Informatica,

how we do performence tuning in informatica

3 Answers  

Can we get 1st record through Informatica(without sequence number).

0 Answers  




explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,

how will you remove the duplicate records from flat file without using sorter?

7 Answers  

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  

Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,

My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,

Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,

From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,

For more Informatica Interview Questions Click Here
Categories