loading float value

[IBMDS]

I am extracting data from sequential file and load into Teradata table, In table one column datatype is 'float'. Here I am getting the following error.

Error when checking operator: Type mismatch for field 'RSK_NO'. Fatal error.

Teradata_Enterprise_241: Error when checking operator: Input record and output table schemas are not compatible.
Error when checking operator: Cannot prepare target table.

Please suggest me, how to load float values in teradata

Thanks
IBMDS

[ArndW]

What (exactly) have you declared the column's data type to be in Teradata? And what data type in DataStage?

[IBMDS]

In teradata table, its float and in DataStage also defined as float

[ArndW]

IBMDS - how many digits of precision? The message,

Type mismatch for field 'RSK_NO'. Fatal error

is pretty clear that somewhere there is a discrepancy. How did you determine the Teradata DDL?

[IBMDS]

The source data looks like this

0.0302841
0.143932
0.044229
0.0474514
0
0.099517
0.00209654


Thanks
IBMDS

[IBMDS]

I imported table using plug-in metadata definition. its float and i verified the table(show table in teradata). its defined as float.

Thanks
IBMDS

[ArndW]

In the Float metadata have you enable "allow all zeroes"?

[ray.wurlod]

Try importing the table definition using Orchestrate orchdbutil facility. Compare the two table definitions to see whether there are any differences. Even if you can't see any, replace the table definition in the job with the one imported using orchdbutil, and see whether that solves the problem. The orchdbutil facility is known to handle metadata more accurately than other importers.

[battaliou]

Did you fix this error? We had the same problem using decimals, as our TD supports a maximum of decimal(18) so when we had to populate a 38,2 we simply defined it as an 18,2 in DS.

[qt_ky]

You just replied to a 4-year old message.