Insert else update option in which situation we will use
Answer Posted / sushma
We set this property when the lookup TRFM uses dynamic
cache and the session preperty TREAT SOURCE ROWS
AS "Insert" has been set.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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?
How many number of sessions can one group in batches?
Explain the different kinds of facts.
How can we improve session performance in aggregator transformation?
How can we remove the duplicates from flat file source?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Is it possible to create multiple domains on a single Informatica server?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How to generate or load values in to the target table based on a column value using informatica etl tool.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Mention a few design and development best practices for informatica?
How we can create indexes after completing the loan process?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is sequence generator transformation in informatica?