Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.2.2
  3. Part 2: Version 10.2.1
  4. Part 3: Version 10.2
  5. Part 4: Version 10.1.1
  6. Part 5: Version 10.1

DDL Query

DDL Query

Effective in version 10.1, when you choose to create or replace the target at run time, you can define a DDL query based on which the Data Integration Service must create or replace the target table at run time. You can define a DDL query for relational and Hive targets.
You can enter placeholders in the DDL query. The Data Integration Service substitutes the placeholders with the actual values at run time. For example, if a table contains 50 columns, instead of entering all the column names in the DDL query, you can enter a placeholder.
You can enter the following placeholders in the DDL query:
  • INFA_TABLE_NAME
  • INFA_COLUMN_LIST
  • INFA_PORT_SELECTOR
You can also enter parameters in the DDL query.
For more information, see the
Informatica 10.1 Developer Mapping Guide
.


Updated July 27, 2020