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
- 11406 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 |
complex mapping ur project u r invlve can u explain and give real time example give me ?
If we set dd_insert in mapping and Delete in session properties what will happen.?
What is domain and gateway node?
What is source qualifier transformation in informatica?
who to split dimentions into sub dimention
What is the difference between unicode & ascii mode data movement in informatica?
how to insert header after each group.
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
How to join three sources using joiner?
How will you check the bottle necks in informatica? From where do you start checking?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
What is Code Page Compatibility?
Teradata 
