Interested to Buy Any Domain ? << Click Here >> for more details...
By using Transformation i need top most 5 employee salary
from each deptwise? Deptno 10,20,30? which transformation
we need to use?
- 8 Answers
- 18890 Views
- I also Faced
- E-Mail Answers
Answer Posted / kiran
CREATE ONE ROUTER IN THIS CREATE 3 OUTPUT PORTS LIKE DEPT10,DEPT20,DEPT30.THEN OUTPUT OF THIS GIVE TO RANK IN RANK SPECIFY TOP AND NO OF RNAKS 5 THE WE GET EACH DEPT WISE TOP 5 RANKS.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the guidelines to be followed while using union transformation?
How can we use mapping variables in informatica? Where do we use them?
What is the procedure for creating independent data marts from informatica 7.1?
What is joiner transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What are the types of schemas we have in data warehouse and what are the difference between them?
What is resilience time?
How can you define user defied event?
Can you use flat files in Mapplets.
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is the command used to run a batch?
Explain the aggregator transformation?
What are the components of Informatica? And what is the purpose of each?
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 is domain in terms of informatica?
