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


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

Post New Answer

More Informatica Interview Questions

What are the differences between a connected lookup and unconnected lookup?

0 Answers  


In informatica workflow manager, how many repositories can be created?

0 Answers  


What is an expression transformation?

0 Answers  


HOW TO DELETE A RECORD FROM FLAT FILE

6 Answers   TCS,


What is source qualifier transformation in informatica?

0 Answers  






What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,


By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  


How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,


What is the command used to run a batch?

0 Answers  


we have to use order by,where,having we to implement sql query

1 Answers   Satyam,


What are the new features of Power Center 5.0?

0 Answers  


what is Active lock explain

0 Answers   Satyam,


Categories