data-solution-automation-engine / data-warehouse-automation-metadata-schema

Generic interface exchange format for Data Warehouse Automation and ETL generation.
GNU Lesser General Public License v3.0
38 stars 11 forks source link

Make SourceDataObject and SourceDataItem collections instead of single objects #9

Closed RoelantVos closed 4 years ago

RoelantVos commented 4 years ago

Currently a single source is mapped to a target, both at DataObject and DataItem level. For flexibility, it may be better to allow an array / list of sources to map to a target.

In templating engines i.e. Handlebars the index of this array can be used to select a specific item in this list, which usually would just be [0] for a single item. But having multiple options allows for more complex transformations to be developed.