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

Row Strategy Functions (Row-Based Mode)

Row Strategy Functions (Row-Based Mode)

The row strategy functions allow you to access and configure the update strategy for each row.
PowerCenter provides the following row strategy functions:
  • INFA_CTGetRowStrategy().
    Allows the procedure to get the update strategy for a row.
    Use the following syntax:
    INFA_STATUS INFA_CTGetRowStrategy(INFA_CT_INPUTGROUP_HANDLE group, INFA_CTUpdateStrategy updateStrategy);
    The following table describes the arguments for this function:
    Argument
    Datatype
    Input/
    Output
    Description
    group
    INFA_CT_INPUTGROUP_HANDLE
    Input
    Input group handle.
    updateStrategy
    INFA_CT_UPDATESTRATEGY
    Input
    Update strategy for the input port. The Integration Service uses the following values:
    • eUS_INSERT = 0
    • eUS_UPDATE = 1
    • eUS_DELETE = 2
    • eUS_REJECT = 3
  • INFA_CTSetRowStrategy().
    Sets the update strategy for each row. This overrides the INFA_CTChangeDefaultRowStrategy function.
    Use the following syntax:
    INFA_STATUS INFA_CTSetRowStrategy(INFA_CT_OUTPUTGROUP_HANDLE group, INFA_CT_UPDATESTRATEGY updateStrategy);
    The following table describes the arguments for this function:
    Argument
    Datatype
    Input/
    Output
    Description
    group
    INFA_CT_OUTPUTGROUP_HANDLE
    Input
    Output group handle.
    updateStrategy
    INFA_CT_UPDATESTRATEGY
    Input
    Update strategy you want to set for the output port. Use one of the following values:
    • eUS_INSERT = 0
    • eUS_UPDATE = 1
    • eUS_DELETE = 2
    • eUS_REJECT = 3
The return value datatype is INFA_STATUS. Use INFA_SUCCESS and INFA_FAILURE for the return value.

0 COMMENTS

We’d like to hear from you!