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
- 20527 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
Explain what transformation and how many are there in informatica?
Explain pushdown optimization and types in informatica
What are the tuning techniques you applied during your last project
What are the types of caches in lookup?
How to extract sap data using informatica? What is abap? What are idocs?
Enlist the tasks for which source qualifier transformation is used.
How to handle decimal places while importing a flatfile into informatica?
In informatica workflow manager, how many repositories can be created?
Explain how to import oracle sequence into informatica?
Parameter and variable differences
As union transformation gives UNION ALL output, how you will get the UNION output?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What are the main features of Oracle 8i with context to datawarehouse?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
