Archives of the TeradataForum
Message Posted: Mon, 08 Aug 2005 @ 19:20:25 GMT
| Subj: | | Re: Experiences with ETL Tools |
| |
| From: | | Thomas Buehlmann |
| | A) Is it true that ETL tools actually meet all the ETL development needs. | |
ETL packages today should include components for all general ETL needs. Furthermore the ETL tools should be extensible enough to accommodate
those things that are not delivered as a general component (e.g. customer score algorithms.) I have made very good experiences using good ETL
tools.
| | B) In case the answer to the previous question is NO, do they help with the difficult transformations ? | |
Absolutely. This is the major task of ETL tools. I have seen extremely complex projects being implemented in ETL tools. These did not only
involve complex transformations but also dealt with vast amounts of data.
| | C) ETL tools actually use the parallel features of Teradata extensively? | |
Not sure where you are going with this one. If you refer to the use of TTU, the answer is yes. (the major tools do support the TTU.) If you
refer to SQL, the answer is yes again, since this is under Teradata control.)
Please let me know if you want to discuss more specifics.
| 
