1 / 26

The Data Warehouse

The Data Warehouse. The Place to go for Integrated Data. Norman H Stevens Stevnh@inel.gov 208-526-7906. 07 – November - 2003. Replace Legacy Systems . Let users pick Replacement software Human Resources chose Peoplesoft Maintenance chose Passport Accounting chose Oracle Financials

gloriann
Download Presentation

The Data Warehouse

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The Data Warehouse The Place to go for Integrated Data Norman H Stevens Stevnh@inel.gov 208-526-7906 07 – November - 2003

  2. Replace Legacy Systems • Let users pick Replacement software • Human Resources chose Peoplesoft • Maintenance chose Passport • Accounting chose Oracle Financials • Planning uses IPS 2000 • Why not, they are all Oracle Databases?

  3. ERP systems use Thousands of Tables • Each ERP system uses thousands of Tables • Data Items do not have standard sizes • ERP systems leave reporting to the companies that procure them

  4. Data Warehouse standardizes Data Item size • DW team integrates data • Extracts data from source system and loads using SQLLoader • Uses warehouse builder to create maps and extracts data directly from database • DW team builds standard reports • DW makes reports available on the web • DW team implements ad hoc reporting system

  5. B.1.02.03.04.05.06 54321234

  6. 54321234 543212 B.1.02.03.04.05.06

  7. B.1.02.03.04.05.06 54321234

  8. 54321234

  9. 54321234

  10. Data Warehouse users can access integrated data using various methods • Standardized WEB Reports • Design Ad Hoc reports • Run customized reports developed by other users

  11. Products we are currently Using • Oracle 9i Database version 9.2.0.2.0 • Oracle 9ias version 9.0.2.2 • Oracle Enterprise Manager version 9.2.0.1.0 • Oracle Warehouse Builder 9i version 9.0.3.33.0 • Internet Developer Suite • Oracle Designer 9i Release 9.0.2.5.0 • Report Builder 9i Release 9.0.2.0.1 • Oracle Discoverer 9i version 9.0.2.53.0

More Related