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

Answers were Sorted based on User's Feedback



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

Answer / pradeepa

We can use an aggregator to group by on deptno and create a
newport to find the max(salary) and load dept no and
salary,we'll get unique deot no and the max salary.

Is This Answer Correct ?    15 Yes 0 No

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

Answer / syed

we can also use rank transformation by setting top, no of
rank =1 and enable group by port deptno

Is This Answer Correct ?    9 Yes 2 No

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

Answer / janardhanreddy yerraballi

select deptid, empname, salary from
(Select deptid, empname,salary,
rank() Over(Partition by deptid order by salary desc)as rank from
EmpDetails) emp
where emp.rank = 1

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

Which development components of informatica have the highest usage?

0 Answers  


My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,


1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

0 Answers  


How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,






If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,


What are limitations of joiner transformation?

2 Answers   Exilant, TCS,


What are the differences between source qualifier and joiner transformation?

0 Answers  


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers   IBM, TCS,


Enlist the tasks for which source qualifier transformation is used.

0 Answers  


Mention a few design and development best practices for informatica?

0 Answers  


what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,


Categories