You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for data mart


1 to 20 of 32681 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Data Warehousing Guide, 11g Release 2 (11.2)

Glossary

data martfinance. In a dependent data mart, the data can be derived from an enterprise-wide data warehouse. In … an independent data mart, data can be collected directly from sources. … A data warehouse that is designed for a particular line of business, such

Database Data Warehousing Guide, 11g Release 2 (11.2)

Transportation in Data Warehouses

Transportable Tablespaces Example Suppose that you have a data warehouse containing sales data, and…example, the tablespace ts_temp_sales could contain multiple tables. For example, perhaps the data mart … The current month's data must be placed into a separate tablespace in order to be transported. In … this example, you have a tablespace ts_temp_sales, which holds a copy of the current month's data … . Using

Database Data Warehousing Guide, 11g Release 2 (11.2)

Transportation in Data Warehouses

Step 3   Copy the Datafiles and Export File to the Target Systemdata mart platform, using any transportation mechanism for flat files. Once the datafiles have been … Copy the data files that make up ts_temp_sales, as well as the export file jan_sales.dmp to the

Database Data Warehousing Guide, 11g Release 2 (11.2)

Transportation in Data Warehouses

Step 4   Import the MetadataOnce the files have been copied to the data mart, the metadata should be imported into the datamart. You can incorporate this new data into the data mart's tables. You can insert the data from … a permanent part of the data mart.

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Loading Data into Data WarehousesA popular and efficient way to load data into a data warehouse or data mart is to use SQL*Loader … with the DIRECT or PARALLEL option, Data Pump, or to use another loader tool that uses the Oracle … -phase. In one-phase loading, data is loaded directly into the target table, quality

Database Data Warehousing Guide, 11g Release 2 (11.2)

Transportation in Data Warehouses

Overview of Transportation in Data Warehousesdata warehouse to a data mart Transportation is often one of the simpler portions of the ETL process … Transportation is the operation of moving data from one system to another system. In a data … warehouse environment, the most common requirements for transportation are in moving data

Warehouse Builder Data Modeling ETL, and Data Quality Guide,, 11g Release 2 (11.2)

Creating Relational Data Objects

2 Creating Relational Data ObjectsAfter you finish designing your data warehouse or data mart, you are ready to design your target … system. This chapter shows you how to create relational data objects.

Database Data Warehousing Guide, 11g Release 2 (11.2)

Hardware and I/O Considerations in Data Warehouses

Configure I/O for Bandwidth not Capacity, consider a 200GB data mart. Using 72GB drives, this data mart could be built with as few as six drives … Storage configurations for a data warehouse should be chosen based on the I/O bandwidth that they … data, but cannot provide the same I/O throughput as a larger number of small

Database Data Warehousing Guide, 11g Release 2 (11.2)

Database Data Warehousing Guide - Contents

ContentsConventions What's New in Oracle Database? Oracle Database 11g Release 2 (11.2) New Features in Data … Warehousing Oracle Database 11g Release 1 (11.1) New Features in Data Warehousing Part I Concepts 1 … Data Warehousing Concepts What is a Data Warehouse? Subject Oriented Integrated Nonvolatile Time … Variant

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Overview of Materialized View Management Taskslonger useful. After the initial effort of creating and populating the data warehouse or data mart, the … materialized views should be dropped. Archiving old detail and materialized view data that is no … incremental changes from the operational systems. Transforming the data. Verifying that the incremental

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Materialized Views

Rolling Materialized Viewsdata mart contains a time dimension, it is often desirable to archive the oldest information and … and then repopulate the partition with new data. Oracle Database uses this variant of fast refresh … or list partitioned. PCT refresh is nonatomic. Rolling Materialized Views When a data warehouse or … maintenance

Database Data Warehousing Guide, 11g Release 2 (11.2)

Transportation in Data Warehouses

Transportation Using Transportable Tablespacesa staging database to a data warehouse, or in moving data from a data warehouse to a data mart. … Oracle transportable tablespaces are the fastest way for moving large volumes of data between two … Oracle databases. Previous to the introduction of transportable tablespaces, the most

Database Data Warehousing Guide, 11g Release 2 (11.2)

Extraction in Data Warehouses

Extraction Through Distributed Operationstable in a data mart, country_city, and populates it with data from the countries and customers tables … Extracting into Flat Files Using SQL*Plus The most basic technique for extracting data is to … customized format. Note that, using the external table data pump unload facility, you can also extract

Database Data Warehousing Guide, 11g Release 2 (11.2)

Glossary

subject areaknowledge. A data mart is often developed to support a subject area such as sales, marketing, or geography.

Warehouse Builder Data Modeling ETL, and Data Quality Guide,, 11g Release 2 (11.2)

Moving Large Volumes of Data Using Transportable Modules

Benefits of Using Transportable Modulestransportable modules to copy from a read-only data mart to multiple departmental databases. In this way, you … takes relatively less time, you can publish and distribute a data mart for daily analytical or … Before the introduction of transportable modules, the most scalable data transportation method

Database Data Warehousing Guide, 11g Release 2 (11.2)

Glossary

third normal form schemasignificant data loading requirements that is used to feed a data mart and execute long-running queries. Compare with snowflake schema and star schema. … normal form schemas are sometimes chosen for a large data warehouse, especially an environment with

Communications Data Model Reference, 11g Release 2 (11.2)

Communications Data Model Reference - Contents

ContentsConventions Part I Logical and Physical Data Model 1 Introducing Oracle Communications Data Model … Overview of Oracle Communications Data Model What Are the Benefits of Using Oracle Communications Data … Model? What Are the Components of Oracle Communications Data Model? What Oracle Technologies are

Retail Data Model Reference, 11g Release 2 (11.2)

Retail Data Model Reference - Contents

ContentsAccessibility Related Documents Conventions 1 Introducing Oracle Retail Data Model What is Oracle Retail … Data Model? New Features in Oracle Retail Data Model What Are the Components of Oracle Retail Data … Model Oracle Products That Make Up Oracle Retail Data Model Part I Logical and Physical Data

Data Mining Administrator's Guide, 11g Release 2 (11.2)

Data Mining Administrator's Guide - Contents

ContentsConventions What's New in Oracle Data Mining Administration? Oracle Database 11 g Release 2 (11.2.0.3 … ) Oracle Data Mining Oracle Database 11 g Release 2 (11.2.0.2) New Features in Oracle Data Mining Oracle … Database 11g Release 1 New Features in Oracle Data Mining 1 Getting Started with Oracle Data

Airlines Data Model Reference, 11g Release 2 (11.2)

Airlines Data Model Reference - Contents

ContentsConventions Part I Logical and Physical Data Model 1 Introducing Oracle Airlines Data Model What is … Oracle Airlines Data Model? What Are the Benefits of Using Oracle Airlines Data Model? What Are the … Components of Oracle Airlines Data Model? Oracle Products That Make Up Oracle Airlines Data