Archives of the TeradataForum

Message Posted: Mon, 14 Aug 2006 @ 12:00:55 GMT

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

I think I need to rephrase the question. I want to load data from Oracle to Teradata without creating an intermediate file and I need to do this everyday with the system doing the work without any manual intervention. In the Db2 example which I mentioned, the unload from Db2 was done everyday by the Cobol program and the load was done without any flat files being created.

>From what I have seen of Oleload in the reference document 2425, it is only a graphical interface which creates an output file with extension .amj and then that is loaded using fastload or multiload. So here a flat file is created.

And the Named Pipes seems to be for fastexport and fastload pairs..which means teradata to teradata without an intermediate file. Am I missing something here? Or can named pipes be used to get data from Oracle into the named pipe and then use that to load teradata tables?

thanks

Ramaswamy

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