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
- 11569 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 incremental aggregation?
Name the different lookup cache(s)?
What are the conditions needed to improve the performance of informatica aggregator transformation?
what is $$$$?
How union transformation is used?
What is informatica metadata and where is it stored?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
what is INFORMATICA TESTING process
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How you prepared reports for OLAP?
How to extract the informatica rejected data?
What are Dimensional table?
Is it possible to define a single node as a Gateway node as well as worker node?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What are the various types of transformation?
