Home Page for the TeradataForum
 

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023