Answer Posted / shashiall
Swetha answer is correct.Expanding little bit with example.
If there r 3 same salaries..Rank will eliminate the
sequences..try this...rank will come 1,2,3,3,3,6..
To confirm this go to the SQL editor and check this with
Dense rank()function.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Mention few advantages of router transformation over filter transformation.
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What are the different ways to implement parallel processing in informatica?
Is there any way to read the ms excel datas directly into informatica?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is a pre-defined event and user-defined event?
How you prepared reports for OLAP?
Write the prerequisite tasks to achieve the session partition?
What are the types of schemas we have in data warehouse.
Can u generate reports in Informatica?
Quickly characterize reusable change?
How can repository reports be accessed without sql or other transformations?
What is the sequence generator transformation in informatica?
r u done any partitions in ur project?
What will be the approach?