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
- 10187 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
What are the steps involved in the migration from older version to newer version of Informatica Server?
In informatica workflow manager, how many repositories can be created?
Write the different tools in the workflow manager?
Explain what are the different types of transformation available in informatica.
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is domain and gateway node?
Can we create multiple integration service on single repository?
What will be the approach?
Partition, what happens if the specified key range is shorter and longer
In informatics server which files are created during the session rums?
can we override a native sql query within informatica? How do we do it?
What is fact table? Explain the different kinds of facts.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
