Archives of the TeradataForum

Message Posted: Wed, 16 Nov 2005 @ 13:14:44 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Stored procedures results

From:		David Clough

Today, my entire DW, which I modeled and manage, is generated directly from ERwin, including the PPI definitions, table views, and all Join Indexes!. Nothing (and that means NOTHING) gets into the Production database unless it is in the model, both 3NF and Dimensional Models. I can take the Erwin model and generate all the DDL for the entire DW and deploy it to another platform or share bits and pieces of it with other systems. We also use another CASE tool to perform ETL, and basically have no SPs or macros in use, other than my own macros I use for System Administration.

Fantastic!

Thus far we've only managed to do that complete script approach with Oracle (spit).

Could the person who wrote this please, please, please share the Erwin Macros that are used to generate the table DDL which include PPI definitions and Join Indexes?

I use Erwin all the time and would find that approach extremely useful, not to mention interesting.

Just for interest, I generate Views using the following macro:

     REPLACE VIEW DEV%TableProp(Database_Nm)_V.%TableName_V01 AS
     SELECT * FROM
     DEV%TableProp(Database_Nm)_T.%TableName;

Not particularly clever but I find it better than using Erwin's View modelling capability.

_______________________
Dave Clough
Database Designer
Express ICS

www.tnt.com


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Attachments

Library

Quick Reference