How to list Top 10 salary, without using Rank Transmission?
Answer Posted / 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 |
Post New Answer View All Answers
Explain what are the different versions of informatica?
Which are the different editions of informatica powercenter that are available?
how we can load rejected record's at run time?(not through bad files)
How to generate sequence numbers without using the sequence generator transformation?
Explain sessions?
What is rank transform?
Can we change Dynamic to Static or Persistent cache? If so what happens?
State the differences between sql override and lookup override?
What is dimensional table? Explain the different dimensions.
What is data caches/ index caches?
Define pmcmd command?
What are mapplets?
How can you generate reports in informatica?
how tokens will generate?
What is resilience time?