- 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.
- 云化虛擬現(xiàn)實技術(shù)與應(yīng)用
- AutoCAD 2018實用教程(第5版)
- Photoshop 2022從入門到精通
- ANSYS19.0實例詳解
- 中文版3ds Max 2016/VRay效果圖制作實戰(zhàn)基礎(chǔ)教程
- Spring Security 3
- SolidWorks 2021中文版機械設(shè)計從入門到精通
- Excel 2010 商務(wù)數(shù)據(jù)分析與處理(第2版)
- SketchUp印象 城市規(guī)劃項目實踐(第2版)
- 像攝影師一樣調(diào)色
- 跟儲君老師學(xué)Excel極簡思維
- 青少年美育趣味課堂:青少年學(xué)攝影修圖
- 邊做邊學(xué):Photoshop+CorelDRAW綜合實訓(xùn)教程
- SolidWorks2016中文版從入門到精通/CAX工程應(yīng)用叢書
- Apache CXF Web Service Development