Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: UTF-8, Fastload and linux
From:   Joseph V D silva

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020