SAP Knowledge Base Article - Preview

1202473 - Case Sensitive with Table Comparison


Using Table Comparison with Sorted Input. Before the TC, there is a query to sort the input (this can't be passed down to the server because of some derived fields). The results of the Sort Query from DI are in case-sensistive order, meaning "DMLT" shows before "Distribution". For the TC using Sorted Input, SQL Server presents the rows in case-insensitive order, meaning "Distribution" appears before "DMLT". Because of this, DI marks some rows as Deleted and re-inserts them.
Is there a way to change the sort order in DI to be case-insensitive



SAP Data Integrator XI R2


Case Sensitive Sort Order , 614283 , KBA , EIM-DI , Data Integrator, Composer , 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.