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
source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
What is critical mapping?
HOW DO YOU CONNECT TO REMOTE SERVER ?
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
What is the advantage of persistent cache? When it should be used.
What are reusable transformations in how many ways we can create them?
What is the difference between SOURCE and TARGET BASED COMMITS?
Can anyone please distinguish what is Inner join and Outer join
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
How many transformations can be used in mapplets.
What is data merging, data cleansing and sampling?