How to list Top 10 salary, without using Rank Transmission?
Answers were Sorted based on User's Feedback
Answer / raka
SQL:
SELECT id, salary from <table name> where rownum <= 10
ORDER BY salary DESC;
Is This Answer Correct ? | 17 Yes | 20 No |
Answer / abhilash
do following steps
1.in source qualifier override the query with
"order by salary desc"
2. use seq gen tr on it and give column name as "sid"
3. next use filter tr. in that write condition like "sid<=10"
Is This Answer Correct ? | 1 Yes | 4 No |
Answer / amedela chandra sekhar
write sql query in the source qualifier t/r
sql override
select * from(select dense_rank () over (order by sal desc
nulls last)as rnk,emp.* from emp)where rnk<=10;
Is This Answer Correct ? | 0 Yes | 3 No |
Answer / krishnakanth
I hope the simpliest way is what Raka #4 suggested
We can override in the SQL override in the source qualifier
transformation.
Is This Answer Correct ? | 3 Yes | 7 No |
Answer / murugan
only use the Aggregator function.....
first(sal>=values)
Is This Answer Correct ? | 0 Yes | 14 No |
Answer / sarvesh
if it is flat file ur answer is write,if it is relational
souce then go to source qualifier properties there u write
the query like
select distinct a.* from t1 a where 10=(select sal from
t1 b where a.sal>b.sal)
i think it is working
Is This Answer Correct ? | 1 Yes | 24 No |
What is a command that used to run a batch?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
Can anyone tell me the new features in Informatica 9 Version?
How to generate sequence numbers without using the sequence generator transformation?
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
What is Micro Strategy? Why is it used for?
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
Why do we use DSS database for OLAP tools?
Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc
What is the scenario which compels informatica server to reject files?
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?