Sign Up Login


  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

Explain the features of connected and unconnected lookup.

0 Answers  

In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

1 Answers   TCS,

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

9 Answers   Accenture,

What are the new features of informatica 7.1?

2 Answers  

What is rank index in rank transformation?

0 Answers  

what is filelist concept in informatica

4 Answers  

Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.

6 Answers   CTS,

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6 Answers   IBM,

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,

What are Dimensions and various types of Dimensions?

3 Answers   PayPal, TCS,

What is sorter transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories