By using Transformation i need top most 5 employee salary
from each deptwise? Deptno 10,20,30? which transformation
we need to use?
Answer Posted / sujana
v can do dis by using rank tranf... grpby dept no and rankindex=5
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
What is primary and backup node?
How to do unit testing in informatica?
What is native users?
what is the complex transformation you used in informatica
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
what is degenerated dimension?
Explain lookup transformation is active in informatica
What is a standalone command task?
How we can create indexes after completing the loan process?
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
What are the restrictions of union transformation?
What are the different ways to implement parallel processing in informatica?
What is the session task and command task?
Parameter and variable differences
What is sequence generator transformation in informatica?