Interested to Buy Any Domain ? << Click Here >> for more details...
i have flatfile source. i want to load the maximum salary of
each deptno into target. what isthe mapping flow
- 3 Answers
- 11568 Views
- Wipro, I also Faced
- E-Mail Answers
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 You Pull the records on daily basis into your ETL Server.
How to update or delete the rows in a target, which do not have key fields?
wt is Dynamic lookup Transformation? when we use?how we use?
What is a configuration management?
what is mean by flag 4 in update strategy t/r
What is a data modeling?
performance wise which one is better in joiner and lookup transformation
Why we select the table which has minimum number of records as Master table in joiner?
What is the benefit of partitioning a session?
Can you copy the batches?
Explain informatica architecture - version 8 / 9
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
Teradata 
