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
- 10686 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bhaskar
select * from(select * from emp order by sal desc)
where rownum<=5
MINUS
select * from(select * from emp order by sal desc)
where rownum<=4
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain the tuning lookup transformation - informatica
What is data movement mode in Informatica and difference between them?
How can we remove the duplicates from flat file source?
In informatics server which files are created during the session rums?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Under what condition selecting sorted input in aggregator may fail the session?
Briefly define a session task?
What are the informatica performance improvement tips
Explain why we use partitioning the session in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is meant by lookup transformation?
Please let me know how to make encryption and decryption with example?
What are the types of caches in lookup?
What is depict expression change?
