v can do dis by using rank tranf... grpby dept no and rankindex=5

By using Transformation i need top most 5 employee salary
from each deptwise? Deptno 10,20,30? which transformation
we need to use?

Question Posted / sujana

Answer Posted / sujana

Is This Answer Correct ?

11 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How might you approve all mappings in the archive all the while?

1005

Explain pushdown optimization and types in informatica

1054

Which is the t/r that builts only single cache memory?

1177

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1117

Difference between Data and Index Caches?

1126

can we override a native sql query within informatica? Where do we do it?

1100

How to do unit testing in informatica? How to load data in informatica ?

1093

How are the sources and targets definitions imported in informatica designer?

1090

if we have a delimiters at unwanted places in a flat file how can we over come those.

2027

How to update or delete the rows in a target, which do not have key fields?

1166

What are the tasks that source qualifier perform?

1089

What is target load order?

1226

What are the measure objects?

1186

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1264

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2322