Interested to Buy Any Domain ? << Click Here >> for more details...
How to Display top 2 salaries for each department WITHOUT
using Rank Transformation And WITHOUT using SQL queries in
source qualifier.
- 3 Answers
- 20689 Views
- Eureka Forbes, I also Faced
- E-Mail Answers
Answer Posted / dave
Use Aggregator as Transformation with MAX and 2 outputs
| Is This Answer Correct ? | 0 Yes | 10 No |
Post New Answer View All Answers
How to extract sap data using informatica? What is abap? What are idocs?
Explain joiner transformation in informatica
Quickly characterize reusable change?
Design time, run time. If you don't create parameter what will happen
What are the different clients of powercenter?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Explain the different lookup methods used in informatica?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is a sequence generator transformation?
How you prepared reports for OLAP?
What are different types of transformations available in informatica?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is the scenario which compels informatica server to reject files?
Enlist the tasks for which source qualifier transformation is used.
