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
- 4 Answers
- 8745 Views
- IBM, I also Faced
- E-Mail Answers
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
Define the various join types of joiner transformation?
How do you promote a non-reusable transformation to reusable transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
What are the types of lookup transformation?
Differentiate between reusable transformation and mapplet.
What are the different lookup cache(s)?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is the use of an aggregator cache file?
update strategy transformation in informatica
r u done any partitions in ur project?
what is INFORMATICA TESTING process
How many dimensions are there in informatica?
What is pmcmd command?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Which version configuration tool used in ur project?
