官术网_书友最值得收藏!

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.

主站蜘蛛池模板: 福贡县| 九江县| 江山市| 嘉荫县| 河南省| 林周县| 闵行区| 龙南县| 个旧市| 凌海市| 湘乡市| 邹城市| 阜康市| 盐山县| 讷河市| 阳城县| 石家庄市| 清原| 永靖县| 离岛区| 商水县| 富川| 贺兰县| 绥宁县| 隆子县| 内丘县| 萨嘎县| 嫩江县| 金塔县| 宜兴市| 永嘉县| 和龙市| 大埔区| 建昌县| 紫阳县| 广饶县| 南平市| 焉耆| 邵阳市| 菏泽市| 邢台县|