suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping using aggregator & router? how
Answer Posted / sankar
AS PER Reddevilzzzz ANS ALMOST OK
BUT NO NEED TO SELECT GROUP BY IN AGGREGATOR T/R BCOZ IF U
SELECT GROUP BY THERE IS NO DUPLICATE SO WITH OUT
DUPLICATES HOW WE PASS THE DUPLICATES IN T2.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What do you mean by enterprise data warehousing?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Separate from an archive server and a powerhouse?
What is event and what are the tasks related to it?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Explain how many types of dimensions are available in informatica?
What is union transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How to join three sources using joiner? Explain though mapping flow.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is intricate mapping?
What is workflow? What are the components of workflow manager?