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
Under what condition selecting sorted input in aggregator may fail the session?
Explain the scenario which compels informatica server to reject files?
What is a connected transformation?
What is a standalone command task?
What do you mean incremental aggregation?
Which is the t/r that builts only single cache memory?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Define sessions in informatica etl?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is source qualifier transformation in informatica?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What are mapplets? How is it different from a Reusable Transformation?
What is a code page?
what is the difference between informatica6.1 and infomatica7.1
What is meant by incremental aggregation?