Archives of the TeradataForum

Message Posted: Fri, 10 Nov 2006 @ 10:09:02 GMT

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

If I might add to what Mike said, you probably have a concern of too much of space being used up if you use fixed format. That's one thing which I have learnt can be avoided by using a named pipe (often called fifo). Teradata utilities are capable of reading/writing from a fifo. I would assume the oracle utils can do the same, in which case all you will have to do will be to extract the data from oracle to a named fifo and making the fast load to load from the fifo. That way you will virtually use no space in your filesystem. You might want to check if this scenario can be applied in your case.

Joseph Vinish D'silva

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