Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9989 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / krish
there is an option like APPEND IF EXISTS in session
properties
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Explain lookup transformation source types in informatica
What is the difference between router and filter?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How does a rank transform differ from aggregator transform functions max and min?
What is a grid in Informatica?
What all join we can perform in LOOKUP transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How do you load first and last records into target table?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Repository user profiles
What is an expression transformation?
Is there any way to read the ms excel datas directly into informatica?
During the running session, output files are created by informatica server. Enlist few of them.
What are active and passive transformations?
How are the sources and targets definitions imported in informatica designer?
