Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 19176 Views
- I also Faced
- E-Mail Answers
Answer Posted / ashwin
A simple way is here:
1: Drag & drop source and target
2: Create a Rank Transformation in between them
3: Open the rank t/r & go to Ports
4: Give Sal as 'R'(Rank) & Tick Group by on Deptno
5: Goto Properties select Top/Bottom,No.of Ranks=(as you need)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What are the advantages of using informatica as an etl tool over teradata?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
How does the aggregator transformation handle null values?
What are the tuning techniques you applied during your last project
what is SDLC way of code development?
Where is metadata stored?
how tokens will generate?
What are the informatica performance improvement tips
What are the components of Informatica? And what is the purpose of each?
What are the static cache and dynamic cache in informatica?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is joiner transformation?
Explain in detail scd type 2 through mapping.
