Archives of the TeradataForum
Message Posted: Wed, 05 Sep 2007 @ 17:34:01 GMT
| Subj: || || Re: Teradata and ETL |
| From: || || Mogilevsky, Boris |
Hi Kamin, I have been in numerous projects utilizing both approaches and here is my opinion.
When you limit yourself just to basic TD utilities your production support costs are relatively low considering that you just need to have
basic TD skills, though you do not possess great capabilities of ETL tools. But in the last case you are increasing the complexity of your system
and you need to have additional skill set on a personnel side, additional costs associated with ETL server support, etc. One of the projects I was
in we have looked into ETL tools available and finally a decision has been made to perform all sophisticated flat file manipulations in COBOL
before passing massaged data to TD utilities. It worked very good, this was a channel attached environment and we preferred not to send files back
and force from ETL server to TD server considering it would not be as reliable as connection between MF and TD server. So, like people like to
say, 'it all depends' ! Look at your current configuration and how much money you want to spend now and in the future. Production support is very
important as TD warehouses are not cheap.
TERADATA Professional Services