Archives of the TeradataForum

Message Posted: Fri, 16 Mar 2012 @ 21:08:13 GMT

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

Hi,

In our environment, there are separate responsibilities based on the environment.

The data designer uses Erwin to create the physical table DDL. Reviews are held with DBA and ETL Architect/Developer.

Once approved, the data designer creates the main table in development using the Erwin generated DDL. The ETLA/Developer has create rights to generate incremental tables to load the main table.

Once development and development testing is complete, the system integration test (SIT) group is responsible for implementing the changes in the SIT environment based on instructions from ETLA/Developer.

Once the change passes SIT and is approved for production, the production DBA is responsible for implementing the change in the production environment based on the instructions from ETLA/Developer. Changes to the production environment require review and approval by many people before implementation.

Nathan

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