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
- 4 Answers
- 9407 Views
- CTS, I also Faced
- E-Mail Answers
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
How would you join a node to the already existing domain?
What is an Integration service in Informatica?
what is degenerated dimension?
What are the main features of Oracle 8i with context to datawarehouse?
What if the source is a flat-file?
Slowly changing dimensions, types and where will you use them
What is target load order?
How can you define user defied event?
What are the advantages of using informatica as an etl tool over teradata?
What are different types of transformations available in informatica?
What do you understand by SOA of Informatica?
Differentiate between a database and data warehouse?
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?
what is song in infrmatica...?
Scheduling properties,whats the default (sequential)
