Archives of the TeradataForum

Message Posted: Wed, 05 Sep 2007 @ 17:16:41 GMT


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

Subj:		Re: Teradata and ETL

From:		Victor Sokovin

A lot of shops use ETL tools to do the transform and load from the source tables into the warehouse base tables and a lot of shops use just Teradata utilities, SQL and Stored Procs to achieve this. Can someone please comment on these 2 approaches and the advantages and disadvantages of these both approaches?

1. Teradata utilities & SQL (I don't think a lot of shops use stored procedures for ETL or I hope they don't).

Pro: optimal use of well-known and less well-known features; maximum flexibility.

Con: requires Teradata specific knowledge and experience.

2. ETL tools.

Pro: simple applications can be implemented by people with no real knowledge of Teradata; suitable for environments with databases and applications supplied by diverse vendors.

Con: limited use of Teradata features as practically no ETL vendor on the market really follows Teradata; less than optimal performance may be the consequence of the approach.

I would not compare both approaches in terms of costs: you can have an expensive ETL tool or an open source ETL tool etc.

Regards,

Victor


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

Attachments

Library

Quick Reference