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 are the different options available for update strategy?
What does “tail –f” command do and what is its use as an Informatica admin.
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
State the limitations where we cannot use joiner in the mapping pipeline?
What is an expression transformation?
How many numbers of sessions can one group in batches?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
what is $$$$?
What do you mean by enterprise data warehousing?
What are active transformations.
Global and Local shortcuts. Advantages.
What if the source is a flat-file?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is exclusive and normal mode for repository services?