SAP Knowledge Base Article - Preview

2109908 - Teradata nvl/COALESCE push-down issue - Date Services 4.2

Symptom

  • Teradata data source.
  • The nvl() function is not coverted to COALESCE() to puch down to database.
  • Upgrading from Data Services 3.2, a performance problem occurred that the SQL is not pushed down due to nvl() in dataflow.


Read more...

Environment

  • Teradata
  • Data Services 4.2

Product

SAP Data Services 4.0

Keywords

teradata, nvl, coalesce, performance, push-down, optimized SQL , KBA , EIM-DS , Data Services , Bug Filed

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.