Developer Tool Guide

10.4.0
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1

Back Next

Generating and Executing DDL at Run Time

When you select a target schema strategy in a Write transformation in a mapping to create or replace a relational or Hive target at run time, you can define a DDL query.

The Data Integration Service creates or replaces relational and Hive target tables based on the DDL query that you define.

You can define a DDL query to customize the table or you can specify additional parameters such as partitions, based on which the Data Integration Service must create or replace the target table. The table contains the columns that you define in the DDL query. You can also enter placeholders in the DDL query. The Data Integration Service substitutes the placeholders with the actual values at run time.

For more information, see the

Informatica Developer Mapping Guide

Create or Replace Target Tables

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal