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
- 0 Answers
- 1393 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
how do the project develops? pls specify right from the start to end in step by steps.
What is the cumulative sum and moving sum?
What is log file,and where is it located,why u r using the log file
What is intricate mapping?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
how the informatica server sorts the strings values in rank transformations?
Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that
any body can say about all versions of informatica ?how many versions ?
What is the need of an ETL tool?
What does “tail –f” command do and what is its use as an Informatica admin.
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
Teradata 
