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
- 18626 Views
- I also Faced
- E-Mail Answers
Answer Posted / gd
First override source qualifier
Select * from emp where deptno in(10,20,30);
Next sorter T/r sort on salary column desc
Then rank T/r set rank properties top and number of ranks is 5
target achieved
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How to extract sap data using informatica? What is abap? What are idocs?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is aggregator transformation in informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
how to load rows into fact table in data warehouse
how we can load rejected record's at run time?(not through bad files)
Scheduling properties,whats the default (sequential)
What are the issues you have faced in your project? How did you overcome those issues?
What is data movement mode in Informatica and difference between them?
what is $$$$?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
difference between repository database and repository service?
