Archives of the TeradataForum

Message Posted: Mon, 14 Aug 2006 @ 09:19:54 GMT

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

Hi,

you can put an format option to the source field in multiload.

It looks like:

     Insert into table (
     Col1,
     Col2,
     Datecol,
     Col3
     )
     Values(
     :Col1,
     :Col2,
     :Datecol ( Date, Format 'YYMMDD' ),
     Col3
     );

If database space is a premium: With Mulitload you can load directly into the big table ( nor more copies needed )

Don't worry about the way the date it stored in the warehouse - ( you mention 'DDMMYYYY' ). It is always stored as an integer. The format option in the table definition just defines the way, how the date is presented after the select. Once Datecol is defined as a date, Teradata will take care of it.

BR

Christian/Vienna

www.makeitdone.com

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