I am writing a PT script which loads from an oracle source to Teradata.
PROBLEM_COL in Oracle is defined as DECIMAL(10,0). In Teradata PROBLEM_COL is defined as Integer.
The load fails, and all rows are inserted into the error table.
Reviewing the logs I believe I see the problem:

Consider two tables ,one has COLUMN_A defined as a VARCHAR(100) and the other has COLUMN_A defined as an INTEGER. When joining these two tables via COLUMN_A what does the optimizer have to do in order to accomplish the join?Convert VARCHAR to INTEGER  or convert INTEGER to VARCHAR? thanks.

hi, i've got this table with the field ampcputime, which is a integer and used the following text in a query

Dear SQLers,
A small question about time presentation using a integer data type. I juesed INTEGER FORMAT '99:99:99' to show time.
below in steps my chalance :-)

Please explain how this wotks.
SEL SUBSTR(CAST(12345 AS VARCHAR(5)),1,3)
This gives "123" as OP
whereas
SEL SUBSTR(12345,1,3)
gives only "12", why does when passing integer/number it always reduces one explictly and gives output?

Hi All,
I am trying to cast a column into decimal but its failing with the error

Hi,
 
I need to insert data from a field A which is an integer to field B which is TIME(6).
The data in field A is something like this:
 
1. 1256, which means 12:56:00
2. 0145, which means 01:45:00
 
I want to store it in field B as 12:56:00 and 01:45:00
Can you please help?

What is the best way to convert 'yyyy-mm-dd' to the Teradata interger storage of a date? (yyyy-1900)mmdd

For example:

If my date was April 1, 2012 and it was stored in the database column in the format 'yyyy-mm-dd'.

This is what I am trying to get: 1120401

Can anyone please let me know what is the differenc between 'Number' and 'Integer' in Teradata?

Thanks,

Kumar

Would anybody know why I would be getting this error with Teradata 13.10.0.08, and not with Teradata 12?

Conversion from type "DBNull" to type 'Integer' is not valid.

This gets the date, how can I get the full timestamp?

SELECT (CAST('1970/01/01' AS DATE FORMAT 'yyyy/mm/dd')) + CAST(my_time/86400 AS INTEGER) AS CONVERTED_TIME
FROM myDatabase.myTable

I have a table with a column that is an integer and has Unix epoch time data.