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 format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explain sessions and how many types of sessions are there?
Explain lookup transformation is active in informatica
What are the main features of Oracle 8i with context to datawarehouse?
server hot-ws270 is connect to Repository B. What does it mean?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is xml source qualifier transformation in informatica?
Is stop and abort are same in informatica?
What are the advantages of informatica?
What is rank transform?
Which are the different editions of informatica powercenter that are available?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How to do unit testing in informatica?