Preface
Product Overview
Before You Begin
Tutorial Lesson 1
Tutorial Lesson 2
- Creating Source Definitions
  - Viewing Source Definitions
- Creating Target Definitions and Target Tables
  - Creating Target Definitions
  - Creating Target Tables
Tutorial Lesson 3
Tutorial Lesson 4
Tutorial Lesson 5
- Creating a Mapping with Fact and Dimension Tables
- Creating a Workflow
Tutorial Lesson 6
Appendix A: Naming Conventions
- Suggested Naming Conventions
  - Naming Convention
Appendix B: Glossary
- PowerCenter Glossary of Terms

Getting Started

10.5.1
- 10.5.6
- 10.5
- 10.4.0

Back Next

Creating a Target Table

In the following steps, you use the Designer to generate and execute the SQL script to create a target table based on the target definition you created.

Select the table T_ITEM_SUMMARY, and then click

Targets

Generate/Execute SQL

In the

Database Object Generation

dialog box, connect to the target database.

Click

Generate from Selected tables

, and select the

Create Table

Primary Key

, and

Create Index

options.

Leave the other options unchanged.

Click

Generate and execute

The Designer notifies you that the file MKTABLES.SQL already exists.

Click

to override the contents of the file and create the target table.

The Designer runs the SQL script to create the T_ITEM_SUMMARY table.

Click

Creating a Target Definition and Target

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

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

Rename Saved Search

Table of Contents

Getting Started

Getting Started

Creating a Target Table

Creating a Target Table