Table of Contents

Search

  1. Preface
  2. Informatica Developer
  3. The Model Repository
  4. Searches in Informatica Developer
  5. Connections
  6. Physical Data Objects
  7. Flat File Data Objects
  8. Logical View of Data
  9. Viewing Data
  10. Application Deployment
  11. Application Patch Deployment
  12. Application Patch Deployment Example
  13. Continuous Integration and Continuous Delivery (CI/CD)
  14. Object Import and Export
  15. Appendix A: Data Type Reference
  16. Appendix B: Keyboard Shortcuts
  17. Appendix C: Connection Properties

Developer Tool Guide

Developer Tool Guide

Entering a User-Defined Join

Entering a User-Defined Join

Configure a user-defined join in a customized data object or relational data object to define the join condition for the data object sources.
  1. Open the customized data object or relational data object instance.
  2. Select the
    Read
    view.
  3. Select the Output transformation.
  4. Select the
    Query
    properties.
  5. Select the simple query.
  6. Click
    Edit
    next to the
    Join
    field.
    The
    SQL Query
    dialog box appears.
  7. Enter the user-defined join in the
    SQL Query
    field.
    You can select column names from the
    Columns
    list.
  8. Click
    OK
    .
  9. Click
    Validate
    to validate the user-defined join.
  10. Save the data object.

0 COMMENTS

We’d like to hear from you!