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

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

Content

Hi,

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. 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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