Single Star, Single Data Source, Multiple ETLs

Previous TopicNext TopicContents

In this case, you have one primary data source pulling from the Extended Schema (Px). There is only one Star data warehouse, but you will have different ETL processes. You may need different ETL processes to update certain projects for a different company division at a different time. Because the ETL process is typically meant to run once a day due to limitations of time and staging tables, you could use filtering and multiple data sources inside of one Star instance.

Caution: ETL processes cannot run at the same time. You cannot overlap ETL processes because the staging tables inside the Star are shared and any overlap can cause data corruption.

Related Topics

Setting up Multiple ETLs

Run the ETLs



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014