cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle dimension tables to Azure ADLS

hrichtermn
New Contributor

We’re starting a project to move dozens of Oracle warehouse dimension tables to ADLS, and are using parent/child pipelines to pass table names. The pipelines correctly pass and resolve the table name to operate on. The child pipeline uses Oracle Execute to "select * " from the passed table name and the output goes into a CSV Formatter. Of course the structure of each dimension table is unique, so we receive the error …should be a flattened map data, but found: LinkedHashMap.
I think this is because of the json object from mapper before Oracle-execute going into CSV Formatter

is there a way to ignore this object being passed into CSV formatter?parentChildPipe

1 REPLY 1

hrichtermn
New Contributor

On closer inspection we found that un-checking the Pass Through option in the child’s Oracle-Execute resolved our issue.