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
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are the transformations that are not supported in mapplet?
Explain what are the different types of transformation available in informatica.
How do you change a non-reusable transformation to reusable transformation?
What are the components of Informatica? And what is the purpose of each?
What is session task and command task?
Explain the difference between a data warehouse and a data mart?
What is a node in Informatica?
How to do unit testing in informatica? How to load data in informatica ?
What are Dimensional table?
What is the difference between router and filter?
What is a shortcut and copy in Informatica and how two are different with each other?
complex mapping ur project u r invlve can u explain and give real time example give me ?
How to create a non-reusable instance of reusable transformations?
How is union transformation utilized?