Home Page for the TeradataForum

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.



  <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