Forum Discussion

hrichtermn's avatar
hrichtermn
New Contributor
6 years ago

Oracle dimension tables to Azure ADLS

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?

1 Reply

  • hrichtermn's avatar
    hrichtermn
    New Contributor
    6 years ago

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