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?

Answers were Sorted based on User's Feedback



How you load distinct records into one target and duplicate records into another target?..

Answer / moorthy. g

S-SQ-Exp-Rtr-Tgt1/Tgt2

Exp:

flag: decode(true, col1=prev_col1,'Y','N')
pre_col1=col1;

Rtr:
Group1 --- flag='Y' --- Tgt1 -- Duplicate Values
Group2 --- flag='N' --- Tgt2 -- Unique Values

Best Regards,
Manthiramoorthy. G

Is This Answer Correct ?    4 Yes 0 No

How you load distinct records into one target and duplicate records into another target?..

Answer / hema

With an Expression transformation flag the 1st record of a
group with some value say "VALID" and flag the other
records of the same group with value say "DUPLICATES". Then
pass this through a router and then to the different
Targets.(1st target - records with VALID flag and in 2nd
target - records with "DUPLICATES" flag)

Is This Answer Correct ?    5 Yes 2 No

How you load distinct records into one target and duplicate records into another target?..

Answer / 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

More Informatica Interview Questions

Do you have to change the reject file b4 using reject loader utility.

1 Answers  


8.what is mapplet ?give example?

2 Answers  


Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,


A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,


WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,


How to load query faster,so that It will take less time to load?

1 Answers   BNP Paribas,


suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

7 Answers   TCS,


What are the rank caches?

2 Answers   Informatica,


What is Data Caches size?

0 Answers   Informatica,


What is the difference between router and filter?

0 Answers  


Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,


checkout and checkin in informatica 8.6

3 Answers   TCS,


Categories