08-03-2020 05:36 AM
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
08-04-2020 09:40 PM
Figured the issue is in Oracle merge snap which is consuming time.
Thank you