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 can i catch the Duplicate Rows From SorterTrans in a
Seperate Target Table ?

Question Posted / sri

Answers were Sorted based on User's Feedback



How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?..

Answer / krithi

When you use 'Select Distinct' option , the Sorter
Transformation discards the duplicate records.

If you want to trace out the duplicate records, then send
the sorted data into Expression Transformation. Add a new
variable and compare the variable with the input data. If
the data matches then flag the record or else pass the
default row.And load all the flagged records into a
seperate table.

Is This Answer Correct ?    4 Yes 2 No

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?..

Answer / sudhar

You can use distinct to eliminate the duplicate records.

Otherwise if you wanted to send the duplicate records to
another table then sort the data, then using the expression
you can find the duplicate value, assign different constant
values for the duplicate and the normal one. Use the router
to send duplicate and orginal records to the different
target tables.

Is This Answer Correct ?    2 Yes 4 No

Post New Answer

More Informatica Interview Questions

What is polling in informatica ?

1 Answers   TCS,

Explain informatica architecture - version 8 / 9

0 Answers   Informatica,

What is the procedure to load the fact table.Give in detail?

1 Answers  

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,

How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,

difference between informatica 8.6 and 9

3 Answers   Atos Origin, BA Continnum Solutions, Core Logic,

can u any challenge your project?

0 Answers   HP,

While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,

what is the size ur source like(file system or database)? how many record daily come u r banking project?

0 Answers   Cognizant, Flextronics,

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,

For more Informatica Interview Questions Click Here
Categories