How Does Data Integration Order Columns for Load?
Summary:
How does Data Integration order the columns for load?
Content (please ensure you mask any confidential information):
We are integrating some data from an on prem data source into Oracle ARCS, but the column mappings are not matching in the Workbench how we have defined in the integration. Accordingly, we have Attribute columns mapped for the Source and Target:
Target Application mapping:
Source Application Mapping (on prem data source):
Our integration has dimensions appropriately mapped as such:
However, our data in the Workbench does not align with the mappings, and thus does not load properly. How does Data Integration/Exchange determine the order in which to load these columns in the Workbench?