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
- 12602 Views
- Cognizant, HP, TCS, I also Faced
- E-Mail Answers
Answer Posted / dave
May be i understood question wrong , but :
For unique records you can use in Source Qualifier SQL with
having count condition = 1 to cut the unique records to one
target
And for second target same query but with >1 condition
---
| Is This Answer Correct ? | 2 Yes | 9 No |
Post New Answer View All Answers
What is a surrogate key?
What is a filter transformation and why it is an active one?
Can we override a native sql query within informatica?
How would you join a node to the already existing domain?
generate date / time dimension in informatica
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain pushdown optimization $pushdownconfig parameter - informatica
Mention few advantages of router transformation over filter transformation.
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is a repository manager?
What is an expression transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is dimensional table?
without table how to come first record only in oracle?
What is repository manager?
