Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 10168 Views
- IBM, I also Faced
- E-Mail Answers
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
Why union transformation is an active transformation?
During the running session, output files are created by informatica server. Enlist few of them.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
State the differences between sql override and lookup override?
How can you increase the performance in joiner transformation?
Mention few advantages of router transformation over filter transformation.
What are the different options available for update strategy?
What is the advantage of informatica?
Please let me know how to make encryption and decryption with example?
How can informatica be used for an organization?
Briefly define a session task?
Explain why we use partitioning the session in informatica?
How many number of sessions can one group in batches?
Define mapplet?
What do you understand by term role-playing dimension?
