Powercenter - Tables

1 - About

The table in the context of PowerCenter

3 - Properties

3.1 - Columns

Datatype : If the Money datatype does not exist in the database, use Number (p,s) or Decimal. Change the precision to 15 and the scale to 2.

3.1.1 - Foreign key

The identification of the foreign key attributes of the tables is not required. You add it for completeness. Foreign key relationships are typically used only in cases where multiple source tables from the source database are joined.

3.2 - Index

If the target database is Oracle, you cannot add an index to a column that already has the PRIMARY KEY constraint added to it.

3.3 - Metadata extensions Properties

In PowerCenter - Designer, Metadata extensions allow you to extend the metadata stored in the repository by associating information with individual repository objects.

For example, you can store contact information, such as name or email address, with the sources you create.

4 - Creation of a table

In PowerCenter - Designer :

  1. Select the table , and then click Targets > Generate/Execute SQL.
  2. In the Database Object Generation dialog box, connect to the target database.
  3. Click Generate from Selected tables, and select the options (Create Table, Primary Key, Create Index, …)
  4. Click Generate and Execute. The Designer notifies you that the file MKT_EMP.SQL already exists.
  5. Click OK to override the contents of the file and create the target table.
  6. The Designer runs the SQL script to create the table.
  7. Click Close.
dit/powercenter/table.txt · Last modified: 2017/09/06 19:56 by gerardnico