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
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 |
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 |
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 |
How to load only the first and last record of a flat file into the target?
how do u fnd the duplicate rows and how to delete the duplicate rows?
How is union transformation utilized?
What is fact table? Explain the different kinds of facts.
What is the difference between view and materialised view?
how many session run unix environment what command using ?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
What does role playing dimension mean?
What is a configuration management?