Table of Contents

Search

  1. Preface
  2. Data integration tasks
  3. Mapping tasks
  4. Dynamic mapping tasks
  5. Synchronization tasks
  6. Data transfer tasks
  7. Replication tasks
  8. Masking tasks
  9. Masking rules
  10. PowerCenter tasks

Tasks

Tasks

Preprocessing and postprocessing SQL commands

Preprocessing and postprocessing SQL commands

You can run SQL commands before or after a task. For example, you can use SQL commands to drop indexes on the target before the task runs, and then recreate them when the task completes.
Data Integration
does not validate the SQL.
Use the following rules and guidelines when creating the SQL commands:
  • Use any command that is valid for the database type. However,
    Data Integration
    does not allow nested comments, even if the database allows them.
  • Use a semicolon (;) to separate multiple statements.
    Data Integration
    issues a commit after each statement.
  • Data Integration
    ignores semicolons within comments. If you need to use a semicolon outside of comments, you can escape it with a backslash (\).

0 COMMENTS

We’d like to hear from you!