By using Transformation i need top most 5 employee salary
from each deptwise? Deptno 10,20,30? which transformation
we need to use?
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
Explain lookup transformation in informatica
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?
Differentiate between sessions and batches?
Partition, what happens if the specified key range is shorter and longer
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
How to create a non-reusable instance of reusable transformations?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How might you approve all mappings in the archive all the while?
can anyone suggest best free Talend data integration training online
Repository user profiles
Explain why we use partitioning the session in informatica?
What are mapplets?
Write the advantages of partitioning a session?
Briefly define reusable transformation?