Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is the need of an ETL tool?

1079


What is status code in informatica?

1010


How can we use mapping variables in informatica?

1056


what is size of u r database?

2301


What is meant by LDAP users?

1192


What is event and what are the tasks related to it?

1116


Tell me about MD5 functions in informatica

925


How can we delete duplicate rows from flat files?

1212


What is workflow monitor?

1054


How to join three sources using joiner?

1094


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1191


Explain sessions?

1050


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?

1072


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1077


What is rank transformation?

984