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
complex mapping ur project u r invlve can u explain and give real time example give me ?
How many numbers of sessions can one group in batches?
What is meant by pre and post session shell command?
What is resilience time?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is Index Caches size?
What is target designer and target load order?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Sequence generator, when you move from develoment to production how will you reset
Explain load alternative records / rows into multiple targets - informatica
What is an expression transformation in informatica?
I have a flat file, want to reverse the contents of the flat file
What is the cumulative sum and moving sum?
How to Create a folder using pmrep command?
What differs when we choose the sorted input for aggregator transformation?