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 can you differentiate between powercenter and power map?
What are the limitations of joiner transformation?
Explain sessions. Explain how batches are used to combine executions?
What are the settings that you use to configure the joiner transformation?
What is the Rank index port in Rank transformation?
tell me 5 session failure in real time how can you solve that in your project?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
what is size of u r database?
What does command task mean?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is a difference between complete, stop and abort?
What is informatica worklet?
How do you migrate data from one environment to another?