Interested to Buy Any Domain ? << Click Here >> for more details...
how to send unique records to one target and duplicate
records to another target by using dynamic lookup cache?????
please explain me briefly///(when we use this we look up on
which target unique target ya duplicate target)
- 3 Answers
- 12319 Views
- Cognizant, HP, TCS, I also Faced
- E-Mail Answers
Answer Posted / sarvesh
whenever we create dynamic lookup a default col gets added i.e. newlokuprow it has a defaul value 1 for insert that is newrow and 0 for delete or duplicate or same row which already exists. so just use router tr and separate the 0 value row will eliminate the duplicates.
| Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How many dimensions are there in informatica?
How to create Target definition for flat files?
Explain the different kinds of facts.
Is it possible to create multiple domains on a single Informatica server?
How to open an older version of an object in the workspace?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
can anyone explain me about retail domain project in informatica?
What is a sequence generator transformation?
What is decode in static cache?
What do think which one is the better joiner or look up?
Describe data concatenation?
What is the need of etl tools?
What are the uses of etl tools?
During the running session, output files are created by informatica server. Enlist few of them.
