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
- 11577 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 |
Explain incremental aggregation in informatica
what is scd?
When do you use sql override in a lookup transformation?
Which transformation should u need while using the cobol sources as source defintions?
What do mean by local and global repository?
Major difference between SQL override and Lookup Sql override
How can you validate all mappings in the repository simultaneously?
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
In how many ways we can create ports?
what are the output files that the informatica server creats during running a session?
Explian the Process of deployment groups in informatica
Do you have to change the reject file b4 using reject loader utility.
Teradata 
