How you load distinct records into one target and duplicate
records into another target?
Answer Posted / shaik
Create a mapping with two targets.
> Create an Aggregator transformation and group it on the
distinct values and load it into Target1.
> Load the data directly in to Target2 since the source
have duplicates it will load all the duplicates.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What is the need of an ETL tool?
What is status code in informatica?
How can we use mapping variables in informatica?
what is size of u r database?
What is meant by LDAP users?
What is event and what are the tasks related to it?
Tell me about MD5 functions in informatica
How can we delete duplicate rows from flat files?
What is workflow monitor?
How to join three sources using joiner?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Explain sessions?
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?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is rank transformation?