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
Answers were Sorted based on User's Feedback
Answer / krish
there is an option like APPEND IF EXISTS in session
properties
Is This Answer Correct ? | 11 Yes | 1 No |
Answer / 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 |
Answer / 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 |
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is Index Caches size?
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
What are the basic needs to join two sources in a source qualifier?
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?
What is the need for an etl tool?
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
How to retrieve last two days updated records?
What is the Difference between PowerPlay transformer and power play reports?
What is a unit Testing?