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
What are the differences between a connected lookup and unconnected lookup?
In informatica workflow manager, how many repositories can be created?
What is an expression transformation?
HOW TO DELETE A RECORD FROM FLAT FILE
What is source qualifier transformation in informatica?
What is CDC? How to implement CDC?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
What is the command used to run a batch?
we have to use order by,where,having we to implement sql query
What are the new features of Power Center 5.0?
what is Active lock explain