Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.
Not Found
English

Page Not Found

The page or file you are looking for has been moved or no longer exists.

The following links might help you find the content you need:


You can also search the Documentation Portal or visit the home page.

English
  • Data Integration Connectors
  • All Products

Table of Contents

Search

  1. Part 1: Introduction to Amazon Redshift connectors
  2. Part 2: Data Integration with Amazon Redshift V2 Connector
  3. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

Back Next

Adding multiple source objects

Adding multiple source objects

When you create a Source transformation, you can select Amazon Redshift V2 multiple object as the source type and then configure a join to combine the tables. You can define a relationship condition or a query to join the tables.
  1. In the Source transformation, click the
    Source Type
     as
    Multiple Objects
    .
  2. From the
    Actions
     menu, click
    Add Source Object
    .
    The image shows how to add a source object.
  3. Select the source object that you want to add from the displayed list.
    The image shows the list of objects from which you can select a source object.
  4. Click
    OK
    .
  5. From the
    Related Objects Actions
     menu, select
    Advanced Relationship
    : The image shows the Advanced Relationship option.
  6. In the
    Advanced Relationship
     window, you can click
    Add Object
     to add more objects.
    Click Add Object to add more objects.
  7. Click
    OK
    .
  8. Set your own conditions or specify a query to define the relationship between the tables:
    The image shows how you can define a relationship between objects.
    When you configure a join expression, select the fields and define a join condition or a query syntax.
  9. Click
    OK
    .
    The following image shows an example of an advanced join condition defined between the Amazon Redshift V2 tables:
    The image shows how an advanced join condition is displayed in the UI.
0 COMMENTS
We’d like to hear from you!