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
- 20511 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 do you load first and last records into target table?
What do you understand by SOA of Informatica?
What is Cognos script editor?
Why do you use Mapping Parameter and mapping variable?
What is a sequence generator transformation?
can we override a native sql query within informatica? Where do we do it?
How can you validate all mappings in the repository simultaneously?
Reusable transformation and shortcut differences
What is lookup transformation?
What is an expression transformation?
Repository user profiles
What are different types of transformations available in informatica?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What do you mean by worklet?
