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

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  


What is DTM process?

4 Answers  


what is Partitioning ? where we can use Partition?

2 Answers   IBM, TCS,


how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,


My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,


What is log file,and where is it located,why u r using the log file

1 Answers   TCS,


what is curr val use for in sequence generator?

2 Answers   Emphasis,


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

0 Answers  


What is a repository? And how to add it in an informatica client?

0 Answers   Informatica,


can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,


IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,


Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,


Categories