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)
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
Explain pmcmd command usage in informatica
What is target load order?
What is different between the data warehouse and data mart?
What is incremental aggregation?
Is it possible to create multiple domains on a single Informatica server?
In how many ways we can create ports?
How to partition the Session?
What are data-driven sessions?
On which transformations you created partitions in your project?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is status code in informatica?
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?
Reusable transformation and shortcut differences
Where is metadata stored?
Enlist the differences between database and data warehouse.