Open Table Connector

Back Next

Create a target table at runtime

You can use an existing target or create a target to hold the results of a mapping. If you choose to create the target, the agent creates the target if it does not exist already when you run the task.

To specify the target properties, perform the following tasks:

Select the Target transformation in the mapping.

To specify the target, click the

Target

tab.

Select the target connection.

For the target type, choose

Single Object

Parameter

Specify the target object or parameter.

To specify a target object, perform the following tasks:

Click

Select

and choose a target object. You can select an existing target object or create a new target object at runtime.

To create a target object at runtime, select

Create New at Runtime

In the

Object Name

field, enter the name of the target table that you want to create.

In the

Catalog Name with Database Name

field, enter the AWS Glue catalog name and database name in the following format:

In the

Table Location

field, enter the location of the target table data.

Specify the table properties to optimize the table configuration settings.

Click

The following image shows a sample target object:

Open Table targets in mappings

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal

0 COMMENTS

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

Alessio Giordani - March 26, 2025

Hello documentation team,

I want point out that the example print screen is confusing since the table location should be more properly named with the "schema" name not the table name, since the process create the table name folder as the Object Name.

Regards,

Alessio

Informatica Documentation Team - March 27, 2025

Hello Alessio,

We're working to address your comments and will get back to you.

Rename Saved Search

Table of Contents

Open Table Connector

Open Table Connector

Create a target table at runtime

Create a target table at runtime