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 / 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 is the difference between source qualifier transformations source filter to filter transformation?
update strategy transformation in informatica
Which is the t/r that builts only single cache memory?
What is meant by active and passive transformation?
What is the status code in stored procedure transformation?
What is workflow manager?
Define mapplet?
What do you understand by a term domain?
Make a note of the quantity vaults made in informatica?
What is olap (on-line analytical processing?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
To import the flat file definition into the designer where should the flat file be placed?
What are the guidelines to be followed while using union transformation?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance