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
What is different between the data warehouse and data mart?
what is degenerated dimension?
How to use pmcmd utility command?
How might one distinguish in the case of mapping is right or not without associating session?
expain about the tune parameters?
How can we store previous session logs?
Under which circumstances, informatica server creates reject files?
can anyone suggest best free Talend data integration training online
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.
What is the meaning of decode in informatica?
How can we use mapping variables in informatica?
How to join three sources using joiner? Explain though mapping flow.
What is resilience time?
What is rank index in rank transformation?
What is a sequence generator transformation?