/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
Using Table Comparison with Sorted Input. Before the TC, thereis a query to sort the input (this can't be passed down to theserver because of some derived fields). The results of the SortQuery from DI are in case-sensistive order, meaning "DMLT" showsbefore "Distribution". For the TC using Sorted Input, SQL Serverpresents the rows in case-insensitive order, meaning "Distribution"appears before "DMLT". Because of this, DI marks some rows asDeleted and re-inserts them.
Is there a way to change the sort order in DI to becase-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)