PowerExchange for Amazon Redshift User Guide

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

Back Next

Amazon Redshift Dynamic Mapping Example

Your organization has a large amount of data that keeps changing. Your organization needs to incorporate all the updated data in a short span of time. Create a dynamic mapping, where you can refresh the source schema dynamically to fetch the updated data. Add all the dynamic ports to the target to override the metadata of the existing ports.

Import the Amazon Redshift read and write data objects.

Select a project or folder in the

Object Explorer

view.

Click

File

New

Mapping

The

Mapping

dialog box appears.

Enter the name of the mapping in the

Name

field.

Click

Finish

Drag the data object into a mapping.

The

AmazonRedshift Data Object Access

dialog box appears.

Select the

Read

option and click

In the

Data Object

tab, select the

At runtime, get data object columns from data source

check box.

Drag the data object into a mapping.

The

AmazonRedshift Data Object Acess

dialog box appears.

Select the

Write

option and click

In the

Ports

tab, select the value of the

Columns defined by

Mapping Flow

In the

Advanced

tab, specify a value of the

Target Schema Strategy

Select all the source incoming ports and add the ports to the target.

Save and run the mapping.

Amazon Redshift Mappings

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

Amazon Redshift Dynamic Mapping Example

Amazon Redshift Dynamic Mapping Example