empno sal
1 8000
2 9000
3 8000
4 1000 how to get highest sal wise rankings in rank t/r.
- 3 Answers
- 5197 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 |
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
How can u stop a batch?
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
what is the -ve test case in your project.
can you please explain me pre session and post session options?
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
what are challenges that you faced in testing? give solution to it?
Differnce between filter and router?
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
What is router transformation
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
Teradata 
