Oracle International Corporation

Justin Hyde

Jeff Titmas

Saurabh Verma

Amit Goyal

John D Poole

Francoise J Lawrence

Dylan Wan

Gunaranjan Vasireddy

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.

Extensible attributes for data warehouses

In various embodiments, a data integration system is disclosed which enables incremental loads into a data warehouse by developing a data partitioning plan and selectively disabling and enabling indexes to facilitate incremental loads into fact tables.

Optimizing incremental loading of warehouse data

In various embodiments, a data integration system is disclosed which enables dynamically switching between sources for loading data into a data warehouse by utilizing a source-dependent data store at the data warehouse.

Dynamically switching between data sources

Growing community of inventors

Oakland, CA, United States of America

Justin Hyde