empno sal
1 8000
2 9000
3 8000
4 1000 how to get highest sal wise rankings in rank t/r.
- 3 Answers
- 6728 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anoymous
In rank t/r select properties tab
select top and number of ranks is 4
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ganesh
write a query like
select * from <table_name> order by where sal=(select max(sal) from <table_name>)
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / ,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 |
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How to extract original records at one target & Duplicate records at one target?
What is the difference between source qualifier transformations source filter to filter transformation?
what is mapping optimization? wat are the techniques for tat
Differences between connected and unconnected lookup?
what is the diff b/w cached and unchaed look ups
Is it possible to create multiple domains on a single Informatica server?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is the Difference between SetVariable and setmaxvariable in informatica?
What is meant by target load plan?
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
Teradata 
