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 |
Can you start a session inside a batch individually?
What are the different types of Type2 dimension maping?
How can you complete unrcoverable sessions?
What are the types of metadata that stores in repository?
Is it possible to revert a global repository to local one and why?
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
what are the challenge face in u r project?explain me
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
How to extract sap data using informatica? What is abap? What are idocs?
what is the difference between mapplet & stored procedure?
How we will implement Pushdown Optimization and Types in Informatica with better examples
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?