Table of Contents

Search

  1. Preface
  2. Working with Transformations
  3. Aggregator Transformation
  4. Custom Transformation
  5. Custom Transformation Functions
  6. Data Masking Transformation
  7. Data Masking Examples
  8. Expression Transformation
  9. External Procedure Transformation
  10. Filter Transformation
  11. HTTP Transformation
  12. Identity Resolution Transformation
  13. Java Transformation
  14. Java Transformation API Reference
  15. Java Expressions
  16. Java Transformation Example
  17. Joiner Transformation
  18. Lookup Transformation
  19. Lookup Caches
  20. Dynamic Lookup Cache
  21. Normalizer Transformation
  22. Rank Transformation
  23. Router Transformation
  24. Sequence Generator Transformation
  25. Sorter Transformation
  26. Source Qualifier Transformation
  27. SQL Transformation
  28. Using the SQL Transformation in a Mapping
  29. Stored Procedure Transformation
  30. Transaction Control Transformation
  31. Union Transformation
  32. Unstructured Data Transformation
  33. Update Strategy Transformation
  34. XML Transformations

Transformation Guide

Transformation Guide

Creating a Rank Transformation

Creating a Rank Transformation

You can add a Rank transformation anywhere in the mapping after the source qualifier.
To create a Rank transformation:
  1. In the Mapping Designer, click Transformation > Create. Select the Rank transformation. Enter a name for the Rank. The naming convention for Rank transformations is RNK_
    TransformationName
    .
    Enter a description for the transformation. This description appears in the Repository Manager.
  2. Click Create, and then click Done.
    The Designer creates the Rank transformation.
  3. Link columns from an input transformation to the Rank transformation.
  4. Click the Ports tab and select the Rank (R) option for the rank port.
    If you want to create groups for ranked rows, select Group By for the port that defines the group.
  5. Click the Properties tab and select whether you want the top or bottom rank.
  6. For the Number of Ranks option, enter the number of rows you want to select for the rank.
  7. Change the other Rank transformation properties, if necessary.
    The following table describes the Rank transformation properties:
    Setting
    Description
    Cache Directory
    Local directory where the Integration Service creates the index and data cache files. By default, the Integration Service uses the directory entered in the Workflow Manager for the process variable $PMCacheDir. If you enter a new directory, make sure the directory exists and contains enough disk space for the cache files.
    Top/Bottom
    Specifies whether you want the top or bottom ranking for a column.
    Number of Ranks
    Number of rows you want to rank.
    Case-Sensitive String Comparison
    When running in Unicode mode, the Integration Service ranks strings based on the sort order selected for the session. If the session sort order is case sensitive, select this option to enable case-sensitive string comparisons, and clear this option to have the Integration Service ignore case for strings. If the sort order is not case sensitive, the Integration Service ignores this setting. By default, this option is selected.
    Tracing Level
    Determines the amount of information the Integration Service writes to the session log about data passing through this transformation in a session.
    Rank Data Cache Size
    Data cache size for the transformation. Default is 2,000,000 bytes. If the total configured session cache size is 2 GB (2,147,483,648 bytes) or more, you must run the session on a 64-bit Integration Service. You can use a numeric value for the cache, you can use a cache value from a parameter file or you can configure the Integration Service to set the cache size by using the Auto setting. If you configure the Integration Service to determine the cache size, you can also configure a maximum amount of memory for the Integration Service to allocate to the cache.
    Rank Index Cache Size
    Index cache size for the transformation. Default is 1,000,000 bytes. If the total configured session cache size is 2 GB (2,147,483,648 bytes) or more, you must run the session on a 64-bit Integration Service. You can use a numeric value for the cache, you can use a cache value from a parameter file or you can configure the Integration Service to set the cache size by using the Auto setting. If you configure the Integration Service to determine the cache size, you can also configure a maximum amount of memory for the Integration Service to allocate to the cache.
    Transformation Scope
    Specifies how the Integration Service applies the transformation logic to incoming data:
    • Transaction. Applies the transformation logic to all rows in a transaction. Choose Transaction when a row of data depends on all rows in the same transaction, but does not depend on rows in other transactions.
    • All Input. Applies the transformation logic on all incoming data. When you choose All Input, the PowerCenter drops incoming transaction boundaries. Choose All Input when a row of data depends on all rows in the source.
  8. Click OK.

0 COMMENTS

We’d like to hear from you!