Archives of the TeradataForum

Message Posted: Tue, 06 Jul 2004 @ 14:57:01 GMT

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

We have installed Oracle Gateway between out V2R3 system and Oracle 9.2. I must say I am underwhelmed. It sits on top of ODBC so any limitations within it are experience through the Gateway. Two of the biggest problems were 1)sending data up to TD and 2)Date format incompatibility.

Insert Select is not supported, so I had to loop through a cursor on Oracle to send records up one at a time. One million, one column rows (20gb) took 4.5 hours. Download of the same dataset took 2 minutes.

We have found problems with datatypes, particularly dates. I had to use the CAST function in the Oracle select to get it recognized across the Gateway CAST('30-apr-2004' as date). Oracle tech support is suggesting adding an AAA dateform parameter to the ODBC driver to help date recognition. These problems are magnified when an Oracle Application like Discoverer is put on top of the Gateway because the transformation does not seem to pass through very well.

I have found TD OLEMode a much more efficient (if more Spartan) utility. I would also suggest leaving as much aggregation and summarization on the source to reduce data transfer.

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