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

how to obtain performance data for individual transformations.

2 Answers  


Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers  


In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers  


explain different types of modeling.

2 Answers  


A session S_MAP1 is in Repository A. While running the session error message has displayed

1 Answers  


Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers  


Can we make worklet inside worklet?

1 Answers  


hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers   HP,


what is difference between dimention table and fact table?

1 Answers  


What is Index Caches size?

0 Answers   Informatica,


How to delete the data in the target table after loaded.

3 Answers   TCS,


Categories