in aggregator transformation we want to get middle record
how to implement, source containg empno,name sal,deptno,address



in aggregator transformation we want to get middle record how to implement, source containg empno,n..

Answer / venkat8510

Please follow the below, that would be helpful.

https://www.bullraider.com/database/informatica/scenario/101-informatica-scenario35

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is the difference Between Mapping parameter and variable

3 Answers   Accenture,


Issue with Update override at Target table in Informatica.

2 Answers  


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  


What is difference between stored procedure transformation and external procedure transformation?

2 Answers  


What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

2 Answers   IBM, Wipro,


How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

0 Answers   HP,


Explain one complecated mapping?

3 Answers   Fidelity, Wipro,


Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,


How can u stop a batch?

2 Answers  


i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,


Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers   TCS,


what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  


Categories