Transformation Guide

Back Next

Creating the Database Table

The SQL transformation writes product prices to the Prod_Cost relational table. The Prod_Cost table contains unit and package prices for each product. It stores the wholesale, retail, and manufacturing prices by unit and package.

You do not create a relational target definition for the Prod_Cost table in the repository. The SQL transformation generates the SQL statements to update the table in the database.

The Prod_Cost table contains the following columns:

Type of Costs	Datatype	Description
ProductID	varchar	A unique number that identifies the product to update.
WUnitPrice	number	Wholesale unit price.
WPkgPrice	number	Wholesale package price.
RUnitPrice	number	Retail unit price.
RPkgPrice	number	Retail package price.
MUnitPrice	number	Manufacturers unit price.
MPkgPrice	number	Manufacturers package price.

The following SQL statements create the Prod_Cost table and three product rows on an Oracle database:

Create table Prod_Cost (ProductId varchar (10), WUnitPrice number, WPkgPrice number, RUnitPrice number, RPkgPrice number,MUnitPrice number, MPkgPrice number );
insert into Prod_Cost values('100',0,0,0,0,0,0);
insert into Prod_Cost values('200',0,0,0,0,0,0);
insert into Prod_Cost values('300',0,0,0,0,0,0);
commit;

Rename Saved Search

Table of Contents

Transformation Guide

Transformation Guide

Creating the Database Table

Creating the Database Table