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
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 |
my session have to run Monday to Saturday not run sunday how to sedule in informatica level?
1 Answers Infinite Computer Solutions,
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
TELL ME ABOUT WORK FLOW SCHEDULING?
what transformations are used for Variable port?
what is unique constraint error ?
What is an aggregator transformation? it is active why cant it be passive explain?
In development project what is the process to follow for an etl developer from day1
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
Is it possible to define a single node as a Gateway node as well as worker node?
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan