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.