Table of Contents

Search

  1. Preface
  2. Introduction to Data Integration Hub
  3. PowerCenter Mappings and Workflows
  4. Data Engineering Integration and Streaming Mapping and Workflows
  5. Data Quality Mappings and Workflows
  6. Informatica Cloud Mappings and Tasks
  7. Data Integration Hub Workflows
  8. Data Integration Hub Transformations
  9. Operational Data Store Dashboard and Reports
  10. Forms Designer
  11. Data Integration Hub Publications and Subscriptions APIs
  12. Data Extraction APIs

Developer Guide

Developer Guide

Step 5. Add a Java Transformation to the Mapping

Step 5. Add a Java Transformation to the Mapping

  1. Copy the Java transformation from the sample mapping. You can find sample mappings in the following location:
    <
    DIH
    InstallationDir>/samples/bds_mappings
    . Under this folder, there are sub-folders with sample mappings for an Oracle publication repository and for a Microsoft SQL Server publication repository.
  2. Map the following fields from the Expression transformation to the Java transformation:
    • PublicationName
    • DX_SERVER_URL
  3. Map the following fields from the Java transformation to the topic table in the target object:
    Java Transformation Field
    Topic Table Field
    DXPublicationInstanceID
    DIH__PUBLICATION_INSTANCE_ID
    DXPublicationInstanceDate
    DIH__PUBLICATION_INSTANCE_DATE
  4. In the target transformation, open the target data object and change the data type of
    DIH__PUBLICATION_INSTANCE_ID
    from
    decimal
    to
    bigint
    .
  5. Save the mapping.

0 COMMENTS

We’d like to hear from you!