Developer Tool Guide

Back Next

Create or Replace Target Tables

In the Developer tool, you can generate a DDL script for one or more relational data objects in the Model repository, and run the DDL script to create or replace tables in the target database. If a target already exists in that database, you can drop the target and re-create it.

You can create or replace target table at design-time or at runtime. To create or replace tables at design-time, you must create and execute the DDL script before you run a mapping. You can configure the write transformation in a mapping to create or replace a relational target at run time.

The Developer tool generates a database-specific version of the DDL script for all supported connection types. If you select a JDBC or ODBC target, the Developer tool generates the ANSI SQL-92 generic data type format. You can generate DDL scripts for the following database types:

IBM DB2

Greenplum

Hive

JDBC

Microsoft SQL Server

Netezza

ODBC

Oracle

Teradata

You cannot generate a DDL script if you use an OLE DB SQL Server connection.

Physical Data Objects

Rules and Guidelines to Create or Replace Target Tables