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
Which version configuration tool used in ur project?
What is the use of transformation?
How can informatica be used for an organization?
What is a joiner transformation and why it is an active one?
Describe data concatenation?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Differences between connected and unconnected lookup?
How would you copy the content of one repository to another repository?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Explain the scenario which compels informatica server to reject files?
How can repository reports be accessed without sql or other transformations?
What is rank transformation?