Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Data ingestion from Oracle to Oracle

Highlighted

Data ingestion from Oracle to Oracle

New Contributor

Hi experts,


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

2. ConvertAvroToJSON

3. ConvertJSONtoSQL

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 ?


Thanks !

Kailash