Interested to Buy Any Domain ? << Click Here >> for more details...
what is rank and dense rank in informatica with any
examples and give sql query for this both ranks
- 4 Answers
- 27689 Views
- I also Faced
- E-Mail Answers
Answer Posted / sunil
dense rank means it is the process of calculating rank for
each group.
deptno rank
10 1
2
3
20 1
2
3
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
wat are deployement groups in informatica, how it will be used for developers
Slowly changing dimensions, types and where will you use them
Can we create two repositories on same database instance in oracle?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is workflow monitor?
How union transformation is used?
What are pre and post-session shell commands?
What is persistent lookup cache?
Enlist the advantages of informatica.
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How to configure mapping in informatica?
How to handle decimal places while importing a flatfile into informatica?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
