How to load semi structure data from a table to file in iics

69 Views Asked by At

need help

I have a table called customer and it ishaving below fields

Customer_id | payload | created_dt | modified_dt

Here payload is json format and remaining fields are relational.

I want to convert json data into relational and load all the data into target including customer_id, created_dt, modified_dt

I'm using hierarchy parser transformation but it accepts only one field as input.

0

There are 0 best solutions below