Hi,
I have one flatfile as target in a mapping . When i am
trying to load data second time into it.
The records already is in flatfile is getting override. I
don't want to override existing records.
Note : we can do this by implementing CDC / Incremental pool
logic if target is relational .
But this is flatfile. So, even i use this same technique it
will override only
So what is the solution ?
Is there any option at session level for flatfile target ?
Advance Thanks
Answer Posted / jz
At session level goto target check only insert, thus every
time session runs it inserts the existing target file.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a predefined event?
Define mapplet?
I have a flat file, want to reverse the contents of the flat file
How does the aggregator transformation handle null values?
What is meant by lookup transformation?
Could you explain what is enterprise data warehouse?
explain abt ur project architecture?
What is a difference between complete, stop and abort?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the types of caches in lookup? Explain them.
What the difference is between a database, a data warehouse and a data mart?
What is a shortcut and copy in Informatica and how two are different with each other?
How do you use reject loader.
explain about unit testing? in real time?
In how many ways we can create ports?