EXTENSIBLE ATTRIBUTES FOR DATA WAREHOUSES

摘要

Systems and methods for implementing extensible attributes in ETL are disclosed. In some examples, attributes configured at a source file may be extracted from the source file. The extracted attributes can be mapped to a target column of a data warehouse table, and then a dynamic ETL script may be generated. The dynamic script may be executed to move data associated with the attributes to an appropriate new column of the data warehouse.

主权项

1. A method, comprising:
receiving metadata from a customer source, the metadata identifying an attribute for a data warehouse table; extracting the attribute from the metadata; determining that the attribute from the metadata does not correspond to a column in the data warehouse table; identifying one or more extension columns in the data warehouse table; mapping the attribute to a target column of the data warehouse table, the target column corresponding to one of the one or more extension columns; generating runtime code to move data associated with the attribute into the target column of the data warehouse table; and executing the runtime code to move the data into the target column.