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

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,


If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 Answers  


What is aggregate cache in aggregator transforamtion?

5 Answers  


On which transformations you created partitions in your project?

0 Answers   Cap Gemini,


Explain informatica architecture - version 8 / 9

0 Answers   Informatica,






Three date formats are there . How to change these three into One format without using expression transformation ?

3 Answers   HP,


What are the ETL tools available in DWH?

6 Answers   Mphasis,


Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

3 Answers   TCS,


Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

0 Answers  


Describe two levels in which update strategy transformation sets?

1 Answers  


When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  


What is an expression transformation?

0 Answers  


Categories