in aggregator transformation we want to get middle record how to implement, sou

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

Question Posted / anu63.p

1 Answers
3111 Views
Cognizant, I also Faced
E-Mail Answers

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 are the data movement modes in informatcia?

1 Answers

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

5 Answers FCS, IBM, Satyam, TCS,

What are the new features of Power Center 5.0?

0 Answers

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers

What are different types of transformations available in informatica?

0 Answers

what is mapping parameter?

2 Answers Cap Gemini,

if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers TCS,

Explain about cumulative Sum or moving sum?

0 Answers Informatica,

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers Patni, Wipro,

Explain constraint based loading in informatica