PowerExchange Interfaces for PowerCenter

Back Next

Using Pre-SQL and Post-SQL Statements to Manage Files and Tables

You can define SQL statements in the

Pre SQL

and

Post SQL

session properties for a nonrelational target to manage files and tables.

You can:

Create an empty file

Truncate a target table

Insert rows into a target table

Watch

Comments

0 COMMENTS

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