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
- 11536 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 are the popular informatica products?
How might you approve all mappings in the archive all the while?
How we can create indexes after completing the loan process?
What is rank transform?
what is the hint? how to use it to reduce the query processing in program?
What is update strategy transform?
without table how to come first record only in oracle?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
explan ur project architecture?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are the limitations of joiner transformation?
What are some examples of informatica etl programs?
Why sorter is an active transformation?
Differences between connected and unconnected lookup?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
