Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Snowflake
  3. Snowflake Connections
  4. PowerExchange for Snowflake Data Objects
  5. PowerExchange for Snowflake Mappings
  6. PowerExchange for Snowflake Dynamic Mappings
  7. Snowflake Run-Time Processing
  8. Pushdown Optimization
  9. Appendix A: Snowflake Data Type Reference

PowerExchange for Snowflake User Guide

PowerExchange for Snowflake User Guide

Create a Mapping

Create a Mapping

After you import the source and target objects, create a mapping to read data from and write data to Snowflake.
In a mapping, you define properties that determine how the Data Integration Service extracts data from or loads data to a data source. Configure pushdown optimization for the source and target objects.
  1. Select a project or folder in the Object Explorer view.
  2. Click
    Tasks
    Create
    .
  3. Click
    File
    New
    Mapping
    .
  4. Enter a mapping name and click
    Finish
    .
    An empty mapping appears in the editor.
  5. Drag a data object to the editor and select Read to add the data object as a source.
  6. Drag a data object to the editor and select Write to add the data object as a target.
  7. On the
    Properties
    tab, select
    Run-time
    .
  8. Select
    Full
    as pushdown type.
    The following image shows the pushdown optimization configuration:
    The pushdown type is selected for full in the example mapping.
  9. Save and run the mapping.

0 COMMENTS

We’d like to hear from you!