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
- 9978 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
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
How many transformations can be used in mapplets.
Enterprise data warehouse your projects phase by phase explain?
What is the use of source qualifier?
In warehouses how many schemas are there?
Explain pmcmd command usage in informatica
Under which circumstances, informatica server creates reject files?
Clarify the utilization of aggregator cache record?
How do you load only null records into target? Explain through mapping flow.
What is a repository? And how to add it in an informatica client?
Explain the tuning lookup transformation - informatica
How do you load alternate records into different tables through mapping flow?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How do you use reject loader.
How many input parameters can exist in an unconnected lookup?
