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
- 20324 Views
- Eureka Forbes, I also Faced
- E-Mail Answers
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
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What are the transformations that are not supported in mapplet?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Define the various join types of joiner transformation?
How does a rank transform differ from aggregator transform functions max and min?
What are the different clients of powercenter?
What are the different versions of informatica?
What are the features of complex mapping?
What is main use of mapplet?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is an expression transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Explain what is informatica metadata and where is it stored?
