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
- 10358 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / krish
there is an option like APPEND IF EXISTS in session
properties
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / 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 |
Answer / jz
At session level goto target check only insert, thus every
time session runs it inserts the existing target file.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are data-driven sessions?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
can we create index and drop index in exsisting table while using infomatica
What r the type of indexes u generally used in informatica?
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
what we require for D.modelling?
SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
How can yoU create or import flat file definition in to the warehouse designer?
Can any one explain or sujjest some sites for scd mappings.Thank you
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
Teradata 
