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

5. Consider the following products data which contain duplicate rows.
A
B
C
C
B
D
B

Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table.
The first table should contain the following output
A
D

The second target should contain the following output
B
B
B
C
C

Question Posted / deepika

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,

Explain scd type 3 through mapping.

0 Answers  

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  

How to join three sources using joiner? Explain though mapping flow.

0 Answers  

What are the reusable transformations?

0 Answers   Informatica,

write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010

2 Answers   Accenture,

What are the different types of Type2 dimension maping?

1 Answers  

What is a transaction control transformation?

0 Answers   Informatica,

Types of error logs in Informatica?

2 Answers  

when we go for unconnected lookup transformation? and why?

5 Answers   Accenture,

what is a junk dimension ?

14 Answers   Atos Origin, Cognizant, HS, NIIT, TCS,

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

For more Informatica Interview Questions Click Here
Categories