Archives of the TeradataForum

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

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

<-- 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>		<<First	<Prev	Next>	Last>>