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
- 18892 Views
- I also Faced
- E-Mail Answers
Answer Posted / gd
First override source qualifier
Select * from emp where deptno in(10,20,30);
Next sorter T/r sort on salary column desc
Then rank T/r set rank properties top and number of ranks is 5
target achieved
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Informatica settings are available in which file?
How you can differentiate between connected lookup and unconnected lookup?
What is a joiner transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
How to do unit testing in informatica? How to load data in informatica ?
How to implement security measures using repository manager?
What are the limitations of joiner transformation?
What is lookup transformation?
What do you mean by filter transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
Make a note of the quantity vaults made in informatica?
Explain the aggregator transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Can we get 1st record through Informatica(without sequence number).
What are the components of Informatica? And what is the purpose of each?
