How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
data mart → finance. 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
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
Step 3 Copy the Datafiles and Export File to the Target System → data 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
Step 4 Import the Metadata → Once the files have been copied to the data mart, the metadata should be imported into the data … mart. 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.
2 Creating Relational Data Objects → After 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.
Overview of Transportation in Data Warehouses → data 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
Data Abstraction → Data abstraction lets you work with the essential properties of data without being too involved … with details. You can design a data structure first, and then design algorithms that manipulate it … . Topics Cursors Composite Variables %ROWTYPE Attribute %TYPE Attribute Abstract Data Types Cursors A … always of
Loading Data into Data Warehouses → A 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
SQL Data Types → The PL/SQL data types include the SQL data types. For information about the SQL data types, see … Oracle Database SQL Language Reference —all information there about data types and subtypes, data type … comparison rules, data conversion, literals, and format models applies to both SQL
Data Type Compatibility → You can assign a collection to a collection variable only if they have the same data type. Having … element type, VARCHAR(15). Collection variables group1 and group2 have the same data type, triplet, but … collection variable group3 has the data type trio. The assignment of group1 to group2 succeeds, but … the assignment of group1
BOOLEAN Data Type → The PL/SQL data type BOOLEAN stores logical values, which are the Boolean values TRUE and FALSE and … expression. For details, see \"BOOLEAN Expressions\". Because SQL has no data type equivalent to BOOLEAN
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
Extraction Through Distributed Operations → table 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
Transportation Using Transportable Tablespaces → a 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
Contents → Conventions 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
Rolling Materialized Views → data 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
Overview of Materialized View Management Tasks → longer 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
Fetching Data with Cursor Variables → statement, which works as described in \"Fetching Data with Explicit Cursors\". The return type of the … a variable whose value is a query. Example 6-26 Fetching Data with Cursor Variables DECLARE cv
3 PL/SQL Data Types → Every PL/SQL constant, variable, parameter, and function return value has a data type that … determines its storage format and its valid values and operations. This chapter explains scalar data types … , which store values with no internal components. For information about composite data types, see … Chapter 5, \"PL/SQL Collections
PLS_INTEGER and BINARY_INTEGER Data Types → The PL/SQL data types PLS_INTEGER and BINARY_INTEGER are identical. For simplicity, this document … uses PLS_INTEGER to mean both PLS_INTEGER and BINARY_INTEGER. The PLS_INTEGER data type stores signed … data type has these advantages over the NUMBER data type and NUMBER subtypes: PLS_INTEGER values