Symptom
- A dot (.) in source is getting converted into NULL on Teradata side during bulk-loading.
- Period is output as Null when bulk loading to Teradata
- A single dot in the source column is converted to NULL during bulk load
- When doing mload in Teradata, the NULLIF statement is as follows NULLIF <fieldname>=(.) for varchar fields.
- NULLIF statement in mload control file is incorrect.
- How to control the NULLIF statement in the mload .ctl file.
- Teradata Multiload control file is corrupt.
Read more...
Environment
- SAP Data Services
- Teradata
Product
SAP Data Services all versions
Keywords
BODS, BODI, DS, DI, Edge, bulk load, NVL, bulkloading , KBA , EIM-DS-EXE , Job Execution , EIM-DS , Data Services , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.