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
- 12449 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
What is an expression transformation in informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are the types of caches in lookup?
COM components can be used in Informatica
where to store informatica rejected data?
What is the scenario which compels informatica server to reject files?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Define update strategy?
What is a repository manager?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the difference between writing a joiner query in ANSI style and THETA style?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
