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
How many numbers of sessions can one group in batches?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Explain pushdown optimization and types in informatica
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How do you update the records with or without using update strategy?
Why union transformation is an active transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is a mapplet/worklet in informatica?
scenario where i can use only concurrent execution of workflow.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the types of presistent cache in look up tr.
What are the various types of transformation?
How big was your fact table
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?