How to extract original records at one target & Duplicate
records at one target? {with out using EXPRESION
transformation and sequence generator transformation?}<-this
is important
Answer Posted / usha
by using dynamic lkp its possible...
in dynamic lkp if we r having 2 records..
i will inser 1st record and will update second record...
when ever data inserted in to the target cache get
refreshed..
we ttake dynamic lkp..
by defaul..new lkp row port is added...
we should enable the associatve port...
here we should give the condition ..
in router we should give condition as newlkp=1--it will
insert...
if newlkp=0 means duplicate recorts
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
define galaxy repository in informatica
Why do we need informatica?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How many input parameters can exist in an unconnected lookup?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How are the sources and targets definitions imported in informatica designer?
Can informatica load heterogeneous targets from heterogeneous sources?
What is the benefit of session partitioning?
In which transformation you cannot drag ports into it?
What do you understand by term role-playing dimension?
What is native users?
Whats there in global repository
How does a sorter cache works?
where to store informatica rejected data? How to extract the informatica rejected data?