Answer Posted / shankar mahadevan
The Designer creates a RANKINDEX port for each Rank
transformation. The Integration Service uses the Rank Index
port to store the ranking position for each row in a group.
For example if a Rank transformation is created on the top
five salespersons for each quarter
(Matrix being Sales Person and Measure is Sales) Criterion
Top or bottom (Quarter is a time based dimension)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Can you generate sequence numbers without using the sequence generator transformation?
What all join we can perform in LOOKUP transformation?
What is meant by a domain?
What are the performance considerations when working with aggregator transformation?
What is Data Caches size?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What differs when we choose the sorted input for aggregator transformation?
What are the modules in Power Center
Mention few advantages of router transformation over filter transformation.
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How to use pmcmd utility command?
How many input parameters can exist in an unconnected lookup?
Separate from a database, an information bazaar, and an information stockroom?
which one is better performance wise joiner or look up
What is a predefined event?
