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 to extract original records at one target & Duplicate
records at one target?

Answers were Sorted based on User's Feedback



How to extract original records at one target & Duplicate records at one target?..

Answer / rag

Hi You can do this another way also
put the expresession transforamtion and read some previous
record with the currect record or any unique column value in
the expression and if they are equal then assign the
flag(means duplicate flag) else
assign the new flage.
pass the duplicate flag records to the filter and goes to
the TB(duplicate records target) and unique values to the
origonal target

Is This Answer Correct ?    0 Yes 2 No

How to extract original records at one target & Duplicate records at one target?..

Answer / saradhi

As of my knowledge i think its possible by Router
Transformation.By writing one condition we can extract the
data with out duplication in one target then automatically
default records means with duplication are transferred in
to another target.

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More Informatica Interview Questions

What is polling in informatica ?

1 Answers   TCS,


without matching columns in two tables. how can you join

5 Answers   BirlaSoft,


What are the data movement modes in informatica?

0 Answers   Informatica,


I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

2 Answers   Zensar,


What is meant by pre and post session shell command?

0 Answers  


what is the difference between onsite & client site?

1 Answers  


write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,


How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,


How to list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,


can we create index and drop index in exsisting table while using infomatica

4 Answers  


Explain the shared cache and re-cache?

0 Answers  


Categories