Interested to Buy Any Domain ? << Click Here >> for more details...
which transformation should we use to get the 5th rank
member from a table in informatica?can we achieve this in
sql?
- 6 Answers
- 10945 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / yaseen
As my knowledge we can write as
select distinctsal from emp A where 5 =
(select count(distinctsal) from emp B where A.sal <= B.sal)
Plz correct me if I am wrong
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What are ETL Tools?
What are the different ways to implement parallel processing in informatica?
What is a filter transformation and why it is an active one?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Explain the use of aggregator cache file?
What are Dimensional table?
What is dimensional table? Explain the different dimensions.
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What if the source is a flat-file?
Target increases every day even though no new record was inserted
Partition, what happens if the specified key range is shorter and longer
Performance tuning in UNIX for informatica mappings?
What are active transformations.
