Archives of the TeradataForum

Message Posted: Mon, 13 Oct 2003 @ 22:41:11 GMT

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

Chan,

The problem with Informatica and any tool is that you are inserting a process in the middle. In general, you are reading from one platform, thru the Informatica server to the target platform. That is two trips across the network and 3 platforms involved.

We have an Oracle datamart that we feed from Teradata. We have Fastexport loaded on the same platform as the oracle datamart. We execute FastExport which pulls data from Teradata and writes it to a pipe which is read by Oracle's SQL Loader... the data goes from database to database and never lands on the file system

When using Informatica, make sure it is using the best utility for the job. There is a sweet spot where it is better to use BTEQ to extract small numbers of rows and the bulk utilities for larger numbers.

Jim

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