Mappings

Back Next

Defining a mapping

To define a mapping, create or edit a mapping, specify the mapping name and location, and optionally enter a mapping description.

Click

New

Mappings

, and then perform one of the following tasks:

To create a mapping from scratch, click

Mapping

and then click

Create

. In the

New Mapping

dialog box, select the mapping type and then click

Continue

If you create a mapping in SQL ELT mode, select the target connection or create a new target connection and then click

To create a mapping based on a template, click the template you want to use and then click

Create

To edit a mapping, on the

Explore

page, navigate to the mapping. In the row that contains the mapping, click

Actions

and select

Edit

The Mapping Designer opens.

To specify the mapping name and location, in the

Mapping Properties

panel, enter a name for the mapping and change the location. Or, you can use the default values if desired.

The default mapping name is

Mapping

followed by a sequential number.

Mapping names can contain alphanumeric characters and underscores (_). Maximum length is 100 characters.

The following reserved words cannot be used:

AND

NOT

PROC_RESULT

SPOUTPUT

NULL

TRUE

FALSE

DD_INSERT

DD_UPDATE

DD_DELETE

DD_REJECT

If the

Explore

page is currently active and a project or folder is selected, the default location for the asset is the selected project or folder. Otherwise, the default location is the location of the most recently saved asset.

You can change the name or location after you save the mapping using the

Explore

page.

Optionally, enter a description of the mapping.

Maximum length is 4000 characters.

Mapping configuration

Download Guide

Watch

Comments

Cloud Data Integration Homepage

0 COMMENTS

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

Rename Saved Search

Table of Contents

Mappings

Mappings

Defining a mapping

Defining a mapping