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
- 11546 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 |
Make a note of the quantity vaults made in informatica?
How you can differentiate between connected lookup and unconnected lookup?
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
What is a surrogate key?Why we use it in a mapping?Pl give an example.
Design a mapping to load the cumulative sum of salaries of employees into target table?
How to Join Tables my Source is having 15 table target is one?
What is workflow? What are the components of the workflow manager?
How will you convert rows into columns or columns into rows
Name the different lookup cache(s)?
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
what are the settiings that u use to cofigure the joiner transformation?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
Teradata 
