PowerExchange for Amazon Redshift User Guide

10.5.4
- 10.5.6
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0

Back Next

Creating a Mapping

After you import the read and write data objects, create a mapping to read data from and write data to Amazon Redshift.

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 read and write data objects.

Select a project or folder in the

Object Explorer

view.

Click

Tasks

Create

Click

File

New

Mapping

Enter a mapping name and click

Finish

An empty mapping appears in the editor.

Drag a data object to the editor and select

Read

to add the data object as a source.

Drag a data object to the editor and select

Write

to add the data object as a target.

On the

Properties

tab, select

Run-time

Select

Full

as pushdown type.

The following image shows the pushdown optimization configuration:

Save and run the mapping.

Pushdown Optimization

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

PowerExchange for Amazon Redshift User Guide

PowerExchange for Amazon Redshift User Guide

Creating a Mapping

Creating a Mapping