empno sal
1 8000
2 9000
3 8000
4 1000 how to get highest sal wise rankings in rank t/r.
Answer Posted / ,ike
well as per my knowledge
sc-->sq-->rank t/r-->target
In the rank transformation need to check rank port of sal
and group by empno.
correct me if i was wrong
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Explain how many types of dimensions are available in informatica?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How to open an older version of an object in the workspace?
Can you use flat files in Mapplets.
What is the difference between writing a joiner query in ANSI style and THETA style?
have u done any performance tuning? how u ll do?
Define Pmrep command?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is joiner transformation?
What does role playing dimension mean?
Explain what are the different types of transformation available in informatica.
What is enterprise data warehousing?
Is it possible to revert a global repository to local one and why?
According to his methodology what all you need before you build a datawarehouse
What is joiner change?