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
- 10359 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / krish
there is an option like APPEND IF EXISTS in session
properties
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
How to join three sources using joiner? Explain though mapping flow.
Design a mapping to load the cumulative sum of salaries of employees into target table?
Can we create two repositories on same database instance in oracle?
How you prepared reports for OLAP?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Different circumstance which drives informatica server to expel records?
explain one complex mapping with logic? sales project?
What are the components of the workflow manager?
What is Session and Batches?
Make a note of the quantity vaults made in informatica?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How can we use batches?
what is SDLC way of code development?
What do you mean by worklet?
design of staging area?
