cancel
Showing results for 
Search instead for 
Did you mean: 

Alternate for JSON Splitter - Split single document into multiple rows

pkk_1
New Contributor

Hi,

I am currently using Json Splitter in a pipeline to split records and send it to Oracle merge. As there are huge records, json splitter processing time is very high.

Tried moving the json splitter and Oracle merge snap into a different pipeline and enabled re-use in pipeline execute. Still no improvement in the performance.

Kindly let me know if there is any alternate for Json Splitter. Tried the below approach in mapper to split single document (consisting multiple objects) into multiple rows. But it returns array of array.

Input file :
SampleInput.txt (267 Bytes)

Mapper expression: {}.extend($response.map((elem, index) => elem)).values()
Target: $

Expected output: image

Best Regards,
Pooja

1 REPLY 1

pkk_1
New Contributor

Figured the issue is in Oracle merge snap which is consuming time.

Thank you