- Oracle Warehouse Builder 11g: Getting Started
- Bob Griesemer
- 292字
- 2021-04-01 13:52:51
Chapter 2. Defining and Importing Source Data Structures
The Warehouse Builder software and Oracle database have been installed, and we're ready to begin building our data warehouse. The first thing we have to do is define what our sources of data will be. If we are going to build a useful data warehouse, we have to know what kinds of information our users are going to need out of the warehouse. To know that, we have to know the following:
- The format in which the data is currently stored and where it is stored.
- Whether there is a transactional database currently in use or not, which supports day-to-day operations and from which we'll be pulling the data.
A transactional database is different from a data warehouse database in that it is designed to support the day-to-day transactions that keep an organization running.
- Whether the database is an Oracle database or another vendor's database such as Microsoft SQL Server.
- Whether there are any flat files of information saved from database tables or other files that users keep, which might be a source of information
A flat file is a file in text format that stores data in some kind of delimited format. The most common example of this kind of file is a CSV file, or a comma-separated file, that can be saved from a spreadsheet or extracted from a database table. It is called a flat file because it is in a text-only format and doesn't need to be interpreted by another program or application to read it.
The Warehouse Builder can help us with importing data from any (or all) of these formats into our data warehouse, and we're going to see how to do that in this chapter.
- Vue.js框架與Web前端開發(fā)從入門到精通
- Photoshop CC摳圖+修圖+調(diào)色+合成+特效標(biāo)準(zhǔn)培訓(xùn)教程（全視頻微課版）
- 數(shù)碼攝影后期高手之路（第2版）
- Inkscape 0.48 Illustrator's Cookbook
- Creo 6.0快速入門、進(jìn)階與精通（升級版）
- Excel 2013電子表格處理
- Cinema 4D電商美工與視覺設(shè)計案例教程（培訓(xùn)教材版）
- AutoCAD 2017從新手到高手
- Photoshop CS6案例教程（第3版）
- 精進(jìn)PPT：PPT設(shè)計思維、技術(shù)與實踐（第3版）
- After Effects 2022從入門到精通
- 24小時玩賺剪映
- 中文版CorelDRAW X7技術(shù)大全
- Cinema 4D/After Effects印象 影視包裝技法精解基礎(chǔ)篇
- Photoshop攝影后期必修5項核心技法 基本調(diào)整+光影校正+色彩修飾+局部處理+銳化降噪