Answer Posted / swetha
The Designer automatically creates a RANKINDEX port for each
Rank transformation. The Informatica Server uses the Rank
Index port to store the ranking position for each record in
a group. For example, if you create a Rank transformation
that ranks the top 5 salespersons for each quarter, the rank
index numbers the salespeople from 1 to 5:
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
Under what condition selecting sorted input in aggregator may fail the session?
What is a node in Informatica?
How to create Target definition for flat files?
hi real timers . iam waiting for ur reply regarding ETL TESTING
what is the size of your data warehousing?
Design a mapping to load a target table with the following values from the above source?
Design time, run time. If you don't create parameter what will happen
What is aggregate cache in aggregator transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is workflow manager?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is data transformation manager process?
What are the differences between joiner transformation and source qualifier transformation?
How to create a non-reusable instance of reusable transformations?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?