what is rank and dense rank in informatica with any
examples and give sql query for this both ranks
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
Design time, run time. If you don't create parameter what will happen
How to update a particular record in target with out running whole workflow?
permutations of mapplet
EXL informatica Questions
What are the measure objects?
What is an expression transformation in informatica?
how to load dimension table and fact table. plz tell me the steps.
What is meant by query override?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is a predefined event?
Briefly define reusable transformation?
What is the function of aggregator transformation?
What is the session task and command task?
In informatics server which files are created during the session rums?
What is flashback table ? Advance thanks