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
- 8748 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / gvmahesh
It's very Simple We have one option at session level.
Double click on session-->Mapping tab-->>Target properties--
>Append if exists(check this option).
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is union transformation in informatica?
How do you handle two sessions in Informatica
What is a filter transformation?
Different qualification between a related rotate toward the sky and isolates look upward?
Difference between Data and Index Caches?
Explain the scenario which compels informatica server to reject files?
What is the need of an ETL tool?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What does command task mean?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
what are the Methods For Creating Reusable Transformations?
What is a sequence generator transformation?
