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

what is mapping optimization? wat are the techniques for tat

2 Answers  

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,

Can anyone briefly describe abt audit table loading?

2 Answers   TCS,

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,




what is hash table in informatica?

1 Answers   Zensar,

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

what is surrogate id ?

3 Answers   IBM,

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

0 Answers  

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,

AT the max how many transformations and mapplets can we use in a mapping ?

1 Answers   Cap Gemini, Cognizant,

Is there any way to read the ms excel datas directly into informatica?

0 Answers  

For more Informatica Interview Questions Click Here
Categories