You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Using lookup-xml in integrations

Received Response
edited Jun 16, 2021 9:25AM in Integration 2 comments



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. 

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!