Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 09 Aug 2005 @ 21:26:04 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Teradata Stored Procedures and ETL
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, August 09, 2005 17:25 -->

Hi all:

I'm developing Stored Procedures ETL templates. Including things such as:

     - error management
     - metadata
     - logging
     - error traceability
     - error tables
     - process control
     - dependency control

The project arquitect has established stored procedures as the standard for ETL development.

I've found stored procedures programming somewhat difficult in teradata. Teradata stored procedures language is not as good as the ones available for other RDBMS's. So the question is:

Is this stored procedures approach common practice in teradata dw projects ?

If this is the case, is there a good samaritan willing to share some of his/her templates with me ?

I see no need for cursors in this project, nothing that cannot be done using the Teradata SQL OLAP extensions.

Many thanks.

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020