Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapping tutorial
  4. Parameters
  5. CLAIRE recommendations
  6. Data catalog discovery
  7. Visio templates

Mappings

Mappings

Creating a mapping in SQL ELT mode

Creating a mapping in SQL ELT mode

To create a mapping in SQL ELT mode, choose
Mapping - SQL ELT
when you create a mapping.
If your organization uses the unified
Home
page and you've configured a primary cloud data warehouse, the target connection is automatically set to your primary cloud data warehouse, but you can change it if you wish. If your organization doesn't use the unified
Home
page or you haven't configured a primary cloud data warehouse, you'll need to choose the cloud platform when you create the mapping.
  1. In
    Data Integration
    , click
    New
    Mappings
    Mapping
    .
  2. Click
    Create
    .
  3. In the
    New Mapping
    dialog box, select
    Mapping - SQL ELT
    and then click
    Continue
    .
    If you've configured a primary cloud data warehouse, the Mapping Designer opens in SQL ELT mode. The target connection is set to your primary cloud data warehouse.
  4. If you haven't configured a primary cloud data warehouse, perform the following steps:
    1. Choose your cloud platform and then click
      Select
      .
      Data Integration
      prompts you to choose the target connection or create a new one.
    2. Select a target connection.
      The
      Target Connection
      list displays the target connections for the cloud platform you selected. If your organization has no target connections for the selected platform, or if you want to use a connection that doesn't appear in the drop-down list, click
      Add Connection
      to create a connection.
    3. Click
      Next
      .
      The Mapping Designer opens in SQL ELT mode. The target connection is configured with the connection you selected.
  5. Configure the target object, configure the source, and add any required transformations to the mapping.
  6. Click
    Save
    to save the mapping.

0 COMMENTS

We’d like to hear from you!