/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
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
Read more...
Product
SAP Data Integrator XI R2
Keywords
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.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)