How to list Top 10 salary, without using Rank Transmission?
Answer Posted / chinthi
SELECT t.sal from ( SELECT sal, Row_Number() OVER (ORDER
BY sal desc) AS rownum FROM table ) t WHERE t.rownum <=
10
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How will the document be delivered to me?
How to create the source and target database connections in server manager?
where to store informatica rejected data?
What are different types of transformations available in informatica?
What is option by which we can run all the sessions in a batch simultaneously?
What is a mapplet/worklet in informatica?
What is meant by query override?
Define sessions in informatica etl?
How do you promote a non-reusable transformation to reusable transformation?
Define pmcmd command?
What is the function of union transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
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
Define mapping and session?
can u give example for factless fact table