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
Contents → Populating Time Dimensions Overlapping Data Populations Part II Performing ETL 4 Overview of … : Defining a Simple PL/SQL Mapping Steps to Perform Extraction, Transformation, and Loading (ETL) Using … Scalability 6 Performing ETL Using Dimensional Objects Using Dimensions in ETL Mappings Loading Data Into … in
ETL → Extraction, transformation, and loading (ETL). The process of extracting data from source systems and bringing it into a data warehouse.
Overview of Extraction, Transformation, and Loading (ETL) → , Transformation, and Loading (ETL) The process of extracting data from source systems and bringing it into the … warehouse is commonly called ETL: extraction, transformation, and loading. ETL refers to a broad … concatenate two columns as part of the SELECT statement. Oracle Database is not itself an ETL tool
ETL → stands for extraction, transformation, and loading. ETL refers to the methods involved in accessing … (extraction, transformation, move) are sometimes used instead of ETL.
ETL Basics in Data Warehousing → What happens during the ETL process? The following tasks are the main actions in the process.
ETL Tools for Data Warehouses → functionality, especially for ETL and the parallel query infrastructure. ETL Tools for Data Warehouses Designing … and maintaining the ETL process is often considered one of the most difficult and resource … -intensive portions of a data warehouse project. Many data warehousing projects use ETL tools to manage this
Performing ETL → Part II Performing ETL Oracle Warehouse Builder enables you to perform Extract, Transform, and Load … (ETL) operations. You can choose among different methods of transforming source data before loading … it into your data warehouse. This part discusses deploying data and ETL objects and data auditing … , \"Creating PL/SQL Mappings\"
Overview of ETL in Data Warehouses → the data warehouse is commonly called ETL, which stands for extraction, transformation, and loading … . Note that ETL refers to a broad process, and not three well-defined steps. The acronym ETL is perhaps … of the process is distinct. Nevertheless, the entire process is known as ETL. The methodology and … tasks
extraction, transformation, and loading (ETL) → See ETL. fact Data that represents a business measure, such as sales or cost data.
Troubleshooting Intra-ETL Performance → To troubleshoot the performance of the intra-ETL: Check the execution plan as described in
Source-ETL Design Considerations → Keep the following points in mind when designing and writing source-ETL for Oracle Retail Data … calendars, other calendars need to be populated using source ETL). See Oracle Retail Data Model Reference … -ETL process before executing the intra-ETL processes). See: The topic about analyzing tables, indexes
Intra-ETL Process Flows → The ORDM_INTRA_ETL_FLW is the complete Intra-ETL process flow designed using Oracle Warehouse … respects the dependency of each individual program. You can execute the intra-ETL packages provided … it, you can use this method to perform the Intra-ETL tasks. Using the ORDM_INTRA_ETL_FLW Workflow … ORDM_INTRA_ETL_FLW is the complete
Troubleshooting the ETL Process → This section contains troubleshooting tips for errors that you may encounter while performing ETL.
Starting ETL Jobs → ETL is the process of extracting data from its source location, transforming it as defined in a … or Control Center Manager as described in the following sections. To start ETL from the Projects … Navigator: Select the mapping or process flow, then select Start from the File menu. For every ETL … of Code Template mappings or Web
11 Scheduling ETL Jobs → \" \"Applying Schedules to ETL Objects\" \"Scheduling ETL Jobs in Oracle Enterprise Manager\"
OLAP Component ETL → populated using the Intra-ETL workflow process OLAP_MAP. The workflow calls procedures/functions defined
Troubleshooting Intra-ETL Performance → To troubleshoot the performance of the intra-ETL: Check the execution plan as described in … comments from the dm_cust_cmnt. If there is not enough data in the dm_cust_cmnt table, check the ETL logic
ETL Lookup Matrix Extension → A new lookup matrix mapping is added, you need to review the mapping and possibly make changes. For more information, see Oracle Communications Data Model Adapters and Analytics Installation Guide.
Configuring ETL Objects → Earlier in the design phase, you defined a logical model for your target system using Oracle Warehouse Builder design objects. This chapter includes reference information for assigning physical properties to mappings and process flows. This chapter presents configuration parameters in the order in which they appear in the user interface. This section contains the following topics: \"Configuring Mappings
Executing the Intra-ETL → Intra-ETL One component of Oracle Retail Data Model is the ORDM_INTRA_ETL_FLW process flow which is a … complete Intra-ETL process composed of sub process flows to populate the derived tables and … the proper order. You can execute the Intra ETL by executing the ORDM_INTRA_ETL_FLW from Oracle … Warehouse Builder. The ORDM_INTRA_ETL_FLW