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
Which transformation should we use to normalise the COBOL and relational sources?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How do you update the records with or without using update strategy?
Which transformation is needed while using the Cobol sources as source definitions?
wf dont have integration severances how you can run?
According to his methodology what all you need before you build a datawarehouse
What are the advantages of using informatica as an etl tool over teradata?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are the prerequisite tasks to achieve the session partition?
What are active and passive transformations?
What are the differences between a connected lookup and unconnected lookup?
Where do we use mapping variables in informatica?
How to extract the informatica rejected data?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures