what is target update override and when we use it?
Answer Posted / 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 |
Post New Answer View All Answers
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Have you worked with/created Parameter file
What is the maplet?
Enlist the differences between database and data warehouse.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
can anyone explain me about retail domain project in informatica?
In informatics server which files are created during the session rums?
How does a rank transform differ from aggregator transform functions max and min?
Can we create a Integration service without a Repository service and vice versa?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Which transformation should we use to normalise the COBOL and relational sources?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is the difference between a repository server and a powerhouse?