I just upgraded from ttu8.1 to ttu8.2. I am loading a Teradata table via the TPT wizard from an Oracle table via fastload (load). When selecting the source table and fields, the tpt wizard does not know how to define the Oracle date field and requires me to edit the definition from a dropdown list. Has anyone else experienced this?
Every combination that I have used from the dropdown list has failed when trying to load to a Teradata timestamp(0) field. Has anyone else had any success moving data from and Oracle DATE to Teradata TIMESTAMP(0)? If so, a sample script would be greatly appreciated! I suspect it might be an ODBC problem. I am selecting the 'Oracle Tables' option from the source versus the 'ODBC DSN' option. The 'ODBC DSN' option always me to see the source tables in the schema I select, but fails when I try to access the fields in any table.
When sourcing an Oracle DATE to be loaded into a date field in a Teradata table, the following has to be done:
Oracle Teradata Source Definition Select Statement Format DATE TIMESTAMP(0) Varchar(19) to_char(inputDateField,''yyyy/mm/dd:hh24:mi:ss'') DATE TIME Varchar(15) to_char(inputDateField,''hh24:mi:ss'') DATE DATE Varchar(10) to_char(inputDateField,''yyyy/mm/dd'')
Use two single quotes instead of a quotation mark.