Date format when importing data using Fastload

[andy1213]

I'm in the process of importing data in CSV format, using Fastload, into Teradata.

The input file includes a date (stored as a string) in the format MM/YYYY. As part of the import process I'd like this to be stored as a date.

I'm trying to do this by defining the DATE field in a specific way, when creating the MULTISET table, e.g.

Month_Year DATE FORMAT 'MM/YYYY'

Unfortunately Fastload doesn't accept his approach (though it does work if I use a simple INSERT process, after creating the aforementioned table)

Any help would be much appreciated!

[DaveWellman]

Hi Andy,

I think you'll need to concatenate the 'day' portion into that value and define the format in the Fastload appropriately.

Something like:

- definition in Fastload is DD/MM/YYYY

- concatenation:  '01'||data_field

This now allows Fastload to process (and pass to TD) as real date and not just a month/year component.

HTH

Dave