Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Using lookup-xml in integrations — Cloud Customer Connect
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
12
Views
2
Comments
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. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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