1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / guest

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

How to do the error handling of if ur source is flatfiles?

0 Answers  

what are the types of Data warehousing ?

1 Answers  

What is version control in informatica ? Advance thanks

6 Answers   HCL, Puma,

what is the process of target load planing?

2 Answers   IBM,

How many cubes create from a single model?

1 Answers  




Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers   Syntel,

what is lookup ?

7 Answers  

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

0 Answers  

Mapplets can you use an active transformation in a mapplet,

1 Answers  

Explain the etl program with few examples.

0 Answers  

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers  

For more Informatica Interview Questions Click Here
Categories