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 is mean by complex business rule ?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is hash partition?
Why should we use star schema in datawarehouse design?
How do we implement materialized view?when to use materialized view?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is workflow variable? When we use workflow variable? Can any one explain me with one example???
diffrence between command task and control task
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
Explain the scenario which compels informatica server to reject files?
how may sources can be used in a mapping at a time?(limit)
Why we require dwh in particular projects?