If we set dd_insert in mapping and Delete in session properties what will happen.?
Answer Posted / usha
It will perform delete.
because session properties overide mapping properties.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is a joiner transformation and why it is an active one?
How do you load first and last records into target table?
Why update strategy and union transformations are active?
If informatica has its scheduler why using third party scheduler?
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?
What is target designer and target load order?
What is DR strategy for Informatica project?
What is the way to execute pl/sql script using informatica mapping?
What will be the approach?
What is joiner transformation?
Differentiate between router and filter transformation?
what is the -ve test case in your project.
What are the new features of informatica 9.x at the developer level?
What are the modules in Power Center
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?