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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / manojdubba

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

what is difference between mapping and mapplet ?

2 Answers   TCS,

What are active transformations.

0 Answers  

Using Expression transformation how to remove duplicate records from a relational source?

4 Answers  

How many repositories can we create in Informatica??

9 Answers   IBM, Patni,

How to elaborate tracing level?

0 Answers  

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

How to call shell scripts from informatica?

0 Answers  

What are the different options used to configure the sequential batches?

2 Answers   Wipro,

What do you understand by a term domain?

0 Answers  

why we use materialized view over view?

1 Answers   Zensar,

For more Informatica Interview Questions Click Here
Categories