How to send duplicates to one target and unique rows to one
target?target is empty
- 9 Answers
- 28031 Views
- Amazon, IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / naresh araveti
source> dynamic lookup>router,2 conditions 1. condition
if column_lkp port is null then insert into target1(unqie)
2. condtion if COLumn_lkp port is not null then insert into
target2(duplicates)
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
How many ways are there to do 'remove duplicate records in informatica'?
Sequence generator, when you move from develoment to production how will you reset
What you know about transaction control transformation?
Explain scd type 3 through mapping.
Under what conditions selecting sorted input in aggregator will still not boost session performance?
my source is junk data how will u remove that junk data by using unix please any one replay me
How can you validate all mappings in the repository simultaneously?
How do you load unique records into one target table and duplicate records into a different target table?
Where are the source flat files kept before running the session?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Explain the informatica workflow?
What is the difference between Active and Passive transformation?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What could be the possible resons of locks by user?
