How to Display top 2 salaries for each department WITHOUT
using Rank Transformation And WITHOUT using SQL queries in
source qualifier.
Answer Posted / ahmed
Use Sorter transformation,apply sort key on sal Col as Desc
and use seq Gen transformation then apply filter on first
two seq numbers...
| Is This Answer Correct ? | 9 Yes | 13 No |
Post New Answer View All Answers
What is intricate mapping?
Please let me know how to make Data masking in informatica..
What the difference is between a database, a data warehouse and a data mart?
What is domain and gateway node?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What are different types of transformations available in informatica?
Separate from an archive server and a powerhouse?
What is the use of an aggregator cache file?
What are the informatica performance improvement tips
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 is a snowflake schema?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
what are the Methods For Creating Reusable Transformations?
Write the advantages of partitioning a session?
What is a pre-defined event and user-defined event?