Alternate for JSON Splitter - Split single document into multiple rows

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:

Best Regards,
Pooja

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

Thank you