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
- 27973 Views
- I also Faced
- E-Mail Answers
Answer Posted / ravikumar2614
Rank creates gaps where as densc Rank will not create gaps(between two ranks).
1st answer is correct
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Explain the different kinds of facts.
Explain sql transformation in script mode examples in informatica
Why sorter is an active transformation?
What are the types of schemas we have in data warehouse.
what are factless facts? And in which scenario will you use such kinds of fact tables.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is a filter transformation?
What all are steps in up gradation of Informatica server?
Reusable transformation and shortcut differences
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Explain about cumulative Sum or moving sum?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is the Rank index port in Rank transformation?
Write the advantages of partitioning a session?
r u done any partitions in ur project?
