We want to create a workflow from an oracle source to a oracle target table. Steps used are below.
1. ExecuteSQL processor -> selecting a single column : select carr_cd from carr_t
4. PUTSQL --> Insert into target_t ("carr_cd") VALUES (?)
When I execute the flow, I get an error saying 'json does not have a value for the required column CARR_CD' in step 3. Is there anything that is missed out ?
Or is the steps correct, is there any other way to do this ?