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
- 11473 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is repository manager?
can we override a native sql query within informatica? How do we do it?
What is the need of an ETL tool?
What does command task mean?
What are the uses of etl tools?
Can we get 1st record through Informatica(without sequence number).
Tell me about Propagate functions in informatica
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is union transformation?
Differentiate between reusable transformation and mapplet.
What is a sequence generator transformation?
How can we create index after completion of load process?
can anyone explain me about retail domain project in informatica?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the use of an aggregator cache file?
