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 / sujana
v can do dis by using rank tranf... grpby dept no and rankindex=5
Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
What is a predefined event?
how we can load rejected record's at run time?(not through bad files)
Is it possible to revert a global repository to local one and why?
What is data caches/ index caches?
What are active transformations.
What could be the possible resons of locks by user?
How do you remove duplicate records in informatica? And how many ways are there to do it?
lookup transformation with screenshots
What is the way to execute pl/sql script using informatica mapping?
Which are the different editions of informatica powercenter that are available?
How to load the data from a flat file into the target where the source flat file name changes daily?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
how to load rows into fact table in data warehouse
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the components of Informatica? And what is the purpose of each?