Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is the benefit of partitioning a session?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What does update strategy mean, and what are the different option of it?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Where can we find the throughput option in informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is decode in informatica?
Explain how many types of dimensions are available in informatica?
What are pre and post-session shell commands?
What is an unconnected transformation?
How to load last n records of file into target table - informatica
Differentiate between router and filter transformation?
What is decode in static cache?
Write the different tools in the workflow manager?
What is rank transform?
