Database Reference
In-Depth Information
Creating a database table
In the earlier section, you saw the steps to import the database table into Informatica.
Informatica PowerCenter tools allow you to create a database table from Informatica. If
you have a table structure available in PowerCenter but the corresponding table is not
available in the database, you will not be able to use the table for your mapping purpose as
you will not be able to provide the required connections to load the data. PowerCenter
provides a very efficient and faster way to generate a database table directly, so you need
not write a
CREATE SQL
statement to generate a table in your database.
For your reference, we will create a table named
TGT_EMPLOYEES
in Oracle Database.
We will perform the following steps:
1. In the designer screen, navigate to
Tools
|
Target Designer
to open the Target
Designer.
2. In the workspace, select the
TGT_EMPLOYEES
target definition.
3. Navigate to
Targets
|
Generate/Execute SQL
.
