PowerExchange for SAP NetWeaver User Guide for PowerCenter

Back Next

Generating and Executing SQL for the Relational Targets

Generate and execute SQL to create relational tables in the database for the relational targets in the processing mapping.

To generate and execute SQL for the relational targets:

In the Target Designer, add the relational target definitions for the processing mapping to the workspace.

For non-hierarchy processing mappings, add the following relational target definitions to the workspace:

ControlRecord

BIC_CII<DataSource_name>

DocumentNumber

For the hierarchy processing mapping, add the following relational target definitions to the workspace:

ControlRecord

E2RSHIE000

E2RSHTX000

E2RSHND000

E2RSHIV000

E2RSHFT000

DocumentNumber

Edit each relational target definition and verify that the database type matches the database type.

Select all the relational target definitions.

Click Targets > Generate/Execute SQL.

Click Connect.

Select the ODBC connection, enter the user name and password, and click Connect.

Select Create Table, Primary Key, and Foreign Key.

Click Generate and Execute SQL.

Watch

Comments

0 COMMENTS

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