Skip navigation.

Dylan's BI Notes

Syndicate content Dylan's BI Study Notes
My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management
Updated: 6 hours 7 min ago

Dimensional Modeling

Mon, 2015-03-30 11:06
Moved the content into a page – Dimensional Modeling
Categories: BI & Warehousing

Source Dependent Extract and Source Independent Load

Tue, 2015-03-24 17:40
Typical data warehousing ETL process involves Extract, Transform, and Load. The concept of Source Dependent Extract (SDE) and Source Independent Load (SIL) are unique part of the BI Apps ETL since┬áBI Apps has a universal data warehouse. Since the staging schema are designed according to the universal data warehouse design, the logic of loading data […]
Categories: BI & Warehousing

BI Apps has an Universal Data Warehouse

Mon, 2015-03-23 13:48
BI Apps data warehouse design is based on an assumption that the data warehouse schema design is independent from OLTP system. The staging schema is an universal staging and the data warehouse is an universal data warehouse. The assumption is that no matter what the source system you are using, the business questions the BI […]
Categories: BI & Warehousing

Extracting Data from Cloud Apps

Thu, 2015-03-05 15:20
I think that it would be easier if the cloud application can be aware of the data integration needs and publish the interfaces proactively. Here are some basic requirements for the applications that can be considered as┬ádata integration friendly: 1. Publish the object data model This is required for source analysis. For example, here is […]
Categories: BI & Warehousing

Cloud to Cloud ETL

Fri, 2015-01-16 20:24
I found that Cloud to Cloud ETL is different from the regular ETL running in the on premise env in several ways: 1. Direct Database Access is not available 2. Complex / Nested Objects 3. Paging 4. Volume Restriction 5. File base approach 6. Data Streaming 7. Data Security / Protection 8. Change data capture […]
Categories: BI & Warehousing