| TeraWin is a utility to assist Database Administrators who are building a data warehouse using the NCR Teradata database. It will produce FastLoad scripts from the SQL DDL used to create a table. It will optionally include the DROP TABLE/CREATE TABLE syntax and the DEFINE statement (The assumption is that the input file aligns with the table definition). It will also generate a COBOL program shell that can be used as a basis for an extract program.
The original version was coded to process DDL that was generated from the ERWin Data Modeling software from Logic Works, Inc. It will process
other CREATE TABLE statements as well. In general, if the each column definition is on a
separate line, the DDL can be processed. An example of an acceptable format is
provided in the Sample output reference. A full description of the DDL style
requirements is documented in the help file.
The utility also will output a tab-delimited file with the approximate row sizes for
each table, enumerating both the raw data size and the overhead size for each row. The
output file can be loaded into a spreadsheet and then you can enter the anticipated row
volumes and calculate the resulting space requirements for the tables. This can be
especially useful when you are initially designing the database.
The final output is a series of CREATE VIEW statements for each table encountered to
create a default view for the table. An example: REPLACE VIEW viewdatabase.tableV AS
SELECT * FROM database.tablename; (The table name has a capital V appended to the name.
The maximum length of the generated name is 30 characters.) |
