 |
 |
Archives of the TeradataForum
Message Posted: Mon, 14 Aug 2006 @ 09:29:39 GMT
| Subj: | | Re: Alternative to Insert/Select |
| |
| From: | | Geoffrey Rommel |
| | ... I had thought I might be able to accomplish this with Multiload or TPUMP with an INMOD exit routine. However when I read the MLOAD
documentation it doesn't look like I can transform the SALE_DATE column as I need to, to get the data into the warehouse table in the format I
need. | |
I'm not quite following you here, Anomy. In an INMOD, you can do any kind of transformation you want.
You didn't say whether the source data is coming from a mainframe or Unix, but since it is a "legacy" system I'll assume it's a mainframe. In
the INMOD, you can have two tables in working-storage for Julian days (one for common years, one for leap years). Then add '20' to the front,
etc., to change the Julian day to whatever format you like, say 'yyyy-mm-dd', and return the record to MultiLoad. In your .DEFINE and .FIELD
statements you describe the record as it comes back from the INMOD, not the original record. You can then say (syntax may not be quite right
here):
.field * mo_better_date char(10);
and insert as usual. MultiLoad will convert the character field to a real date.
Examples are available in the manual, in the SAMPLIB PDS distributed with TDP (or, in Unix, under /usr/sample), and here:
www.teradataforum.com/l030315a.htm
| |
