SAP Knowledge Base Article - Preview

1812470 - A dot in the data is converted to Null when bulk loading to Teradata - Data Services

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 , Data Services Job Execution , EIM-DS , Data Services (Use Subcomponent) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.