By using Transformation i need top most 5 employee salary
from each deptwise? Deptno 10,20,30? which transformation
we need to use?
- 8 Answers
- 17144 Views
- I also Faced
- E-Mail Answers
Answer Posted / suguna
by using rank transformation rank of salary and aggregator
transformation for group by dept wise
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
what is the hint? how to use it to reduce the query processing in program?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
4 yrs etl devloper roles and responsibilities?any body give solutions
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is informatica metadata and where is it stored?
Could you explain what is enterprise data warehouse?
Define pmcmd command?
Sequence generator, when you move from develoment to production how will you reset
What all join we can perform in LOOKUP transformation?
What are the different lookup cache(s)?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is a repository? And how to add it in an informatica client?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is a repository manager?
