Using lookup-xml in integrations
I've been trying to implement a solution which needs to join data from two different files.
File A contains business data and File B(xml) contains reference data.
File C is the output which needs to be stored/sent back to the business.
File C needs to be prepared by joining data from File A and B
File A contains 20k rows ( 15 columns and 2 of them need to be updated/replaced with data from File B which contains approx. 100k rows( 3 columns )
XML predicate works fine but we are seeing performance issues due to the size of lookup file.