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

Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that

5 Answers   TCS,


Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers   Infotech,


explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,


How to display First letter of Names in Caps?

7 Answers  


What you know about transaction control transformation?

0 Answers  


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,


i have 2 session s1 execute s2 load first session fail what is the reason?

1 Answers   L&T,


What is parallel processing in informatica?

0 Answers  


What are the differences between a connected lookup and unconnected lookup?

0 Answers  


What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,


What are the data movement modes in informatica?

0 Answers   Informatica,


while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,


Categories