Powercenter - Tables

Card Puncher Data Processing

About

The table in the context of PowerCenter

Properties

In PowerCenter - Designer :

Columns

Powercenter Table Columns Properties

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.

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.

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.

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.

Powercenter Table Metadata Extensions

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.





Discover More
Card Puncher Data Processing
PowerCenter - Repository Objects

You create repository objects using the and client tools. You can also view the objects in the Navigator window of the . source definitions. Definitions of database objects (table, views, synonyms)...
Powercenter Workflow Manager Connections
PowerCenter - Source

A Source is : a database objects (table, views, synonyms) or files (xml, ...) that provide source data. PowerCenter accesses the following sources: Relational. Oracle, Sybase ASE, Informix,...
Powercenter Workflow Manager Connections
PowerCenter - Targets

PowerCenter can load data into the following targets: Relational. Oracle, Sybase ASE, Sybase IQ, Informix, IBM DB2, Microsoft SQL Server, and Teradata. File. Fixed and delimited flat file and XML....



Share this page:
Follow us:
Task Runner