How to list Top 10 salary, without using Rank Transmission?
Answers were Sorted based on User's Feedback
Answer / ramu
Use source Qualifier Transformation,we can edit the default
sql query and write like as
select * from ( select * from emp
order by sal desc)
where rownum <11;
Is This Answer Correct ? | 29 Yes | 2 No |
Answer / informatica_learner
use sorter--> expression-->filter
1)sorter descend
2)use sequence generator connected expression to generator
sequence,
3)filter the value sequence number greater than 10
Is This Answer Correct ? | 27 Yes | 3 No |
Answer / cool
use sorter transformation with ascending,sequence and filter....
Is This Answer Correct ? | 18 Yes | 2 No |
Answer / giri
First use sorter with salary based and sequent generator next filter transformation
Sorter(salary desending order)-----> Sequent genarator
--------->Filter(seq<=10)
Is This Answer Correct ? | 13 Yes | 1 No |
Answer / infa
If Your Source is Flat file then
1. Sort the sal column in Desc order
2. generate the sequence rownumber either by using a sq
genrator or Exp Transformation say v_count+1
3. use a filter condition and give the filter value as
v_count <= 10
4.Load into the target.
If your source is DB
then use below query
SELECT *FROM
(
SELECT *FROM emp
ORDER BY Sal desc
)
WHERE rownum <= 10
ORDER BY Sal;
Thanks
cheers
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rakhee
No need to use any transformation.
Double click on SQ emp
go to property
click on SQL query
browse it
write query
SELECT EMP.EMPNO, EMP.ENAME, EMP.JOB, EMP.MGR, EMP.HIREDATE, EMP.SAL, EMP.COMM, EMP.DEPTNO
FROM
EMP
WHERE
ROWNUM<=10
ORDER BY SAL DESC
validate it
OK
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / jvdwhinfo
Write sql override in the source qualifier t/r.
select columns from
( select columns,rank() over(order by sal desc ) as
rank from emp)
where rank <=10;
let me know if any corrections.
Thanks.
James
Is This Answer Correct ? | 0 Yes | 2 No |
how DTM buffer size and buffer block size are related
Have you worked with/created Parameter file
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
What are the features of complex mapping?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
what is the difference between onsite & client site?
What is deployment group?
What are the data movement modes in informatcia?
What are the phases in SDLC?
Mention some types of transformation?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
To import the flat file definition into the designer where should the flat file be placed?