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
- 20688 Views
- Eureka Forbes, I also Faced
- E-Mail Answers
Answer Posted / harish konda
connect the Source to sorter and sort the data in Descending
order of salary, department and connect to expression and in
expression generate the sequence of numbers(for eg a port
flag) in such a way that whenever salary changes number
increment to 1, and keep in mind whenever department changes
the numbering should start from 1. And next connect the exp
to Filter and give condition as flag<=2.
| Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
What are the different lookup cache(s)?
Is there any way to read the ms excel datas directly into informatica?
Explain pushdown optimization $pushdownconfig parameter - informatica
Explain sessions. Explain how batches are used to combine executions?
can u give example for factless fact table
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
generate date / time dimension in informatica
What is the reusable transformation?
What is a mapplet/worklet in informatica?
Differentiate between sessions and batches?
What are Dimensional table?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How to open an older version of an object in the workspace?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
Explain transaction control transformation in informatica
