Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - I have flat file source. i want to load the maximum salary of each deptno into target. what is the mapping flow?




672
views
asked marvit September 20, 2014 08:03 AM  

I have flat file source. i want to load the maximum salary of each deptno into target. what is the mapping flow?


           

1 Answers



 
answered By vishnoiprem   0  
 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 dept no and the max salary.
 we can also use rank transformation by setting top, no of rank =1 and enable group by port deptno
 
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert