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.
11 Scheduling ETL Jobs → \" \"Applying Schedules to ETL Objects\" \"Scheduling ETL Jobs in Oracle Enterprise Manager\"
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
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 Mapping Enhancements → ETL mappings have been enhanced to add new transformation capabilities and to improve the … productivity of developers working with flat files and designing and debugging ETL mappings. Features in this … \" \"Web Service and SOA Integration Support for ETL and Data Quality\"
Executing Intra-ETL Workflow → Oracle Communications Data Model intra-ETL workflow is implemented using a PL/SQL package … , PKG_INTRA_ETL_PROCESS. Each component and their subcomponents of intra-ETL workflow have one procedure each … that you set all ETL parameters in DWC_OLAP_PARAMETER and DWC_OLAP_ETL_PARAMETER tables. Invoking PKG_INTRA_ETL_PROCESS.RUN procedure
Design ETL Logic → target objects. To design ETL logic: In the Projects Navigator, expand the Oracle target module, right … detailed procedures in \"Defining Mappings\" in Oracle Warehouse Builder Data Modeling, ETL, and Data … mappings. See \"Designing Process Flows\" in Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide.
OLAP Component ETL → populated using the Intra-ETL workflow process OLAP_MAP. The workflow calls procedures/functions defined
Troubleshooting the ETL Process → This section contains troubleshooting tips for errors that you may encounter while performing ETL.
Troubleshooting Intra-ETL Performance → To troubleshoot the performance of the intra-ETL: Check the execution plan as described in
Scheduling ETL Jobs → You can use any of the following methods to schedule ETL: Use the scheduler. See \"Defining
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.