SAP Knowledge Base Article - Preview

1861862 - Loading a Date field column of Teradata table using MLOAD bulk loader option in Data Services

Symptom

When loading a Date field that is in one format to a destination Teradata table that has different date format using the MLOAD bulk loader option, for example using the following to load:

to_char(Query_FilterExecutionId.TRANS_DT, 'yyyy-mm-dd')

OR

Loading a Null value to a Teradata data field, the data is not loaded and sent to an Teradata error table.

 


Read more...

Environment

  • SAP Data Services 14.0.3.541
  • Teradata 12

 

Product

SAP BusinessObjects Business Intelligence platform 4.0

Keywords

BODI, BODS, DSXI, DI, DS, Bulk Loading, Teradata , KBA , 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.