Database Reference
In-Depth Information
7. Specify the column name, data type, and precision in the data view option.
8. Click on
Finish
to get the target file imported in the Target Designer.
Working with the target - the Create option
Apart from importing the file or table structure, we can manually create the target defini-
tion. When the sample target file or the table structure is not available, we need to manu-
ally create the target structure. When we select the
Create
option, we need to define every
detail related to the file or table manually, such as the name of the target, type of target,
column names, column data type, column data size, indexes, constraints, and so on. When
you import the structure, the import wizard automatically imports all these details. We
perform the following steps:
1. In the designer screen, navigate to
Tools
|
Target Designer
to open the Target
Designer.
2. Navigate to
Target
|
Create
.
3. Select the type of target you wish to create from the drop-down list.
4. An empty target structure will appear in the Target Designer.
5. Double-click on the title bar of the target definition for the
T_EMPLOYEES
table. This will open the
T_EMPLOYEES
target definition.
6. A pop-up window will display all the properties of this target definition. The
Table
tab will show the name of the table, the owner name, and the database type.
You can add a comment in the
Description
section. Usually, we keep the
Busi-
ness name
section empty.
7. Click on the
Columns
tab. This will display the column descriptions for the tar-
get. You can add, delete, or edit the columns.
8. Click on the
Metadata Extensions
tab; usually, you keep this tab blank. You can
store some metadata related to the target you created. Some personal details and
reference details can be saved. Click on
Apply
and then click on
OK
.
9. Navigate to
Repository
|
Save
to save the changes to the repository.
Working with the target - the Copy option
PowerCenter provides a very convenient way of reusing the existing components in the
repository. It provides the
Drag-Drop
feature, which helps when reusing the existing
components.
Using the
Drag-Drop
feature, you can copy the existing source definition, created earlier,
into the Target Designer to create the target definition with the same structure.