How to list Top 10 salary, without using Rank Transmission?
Answer Posted / 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 |
Post New Answer View All Answers
Explain the shared cache and re-cache?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How might one distinguish in the case of mapping is right or not without associating session?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Differentiate between sessions and batches?
What is meant by query override?
How to load a Dimension ? and how to load a fact table?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is a predefined event?
What does role playing dimension mean?
Under which circumstances, informatica server creates reject files?
What do you mean by filter transformation?
What is the difference between informatics 7x and 8x and what is latest version?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?