|
|||||
|
Agenda The Three Layers of ETL Think about Hardware Database Staging area Use and Understand the Database features SQL*Loader or External Tables Direct path Parallelism Partition exchange load Compression Q&A In this session will not cover ETL tools. The main focus will be on the database And how you can do use a key set . . . → Read More: Best Practices for Loading in an Oracle Data Warehouse Designing a 300TB Clustered Data Warehouse Introduction Project Overview Architecture Review (The Two Platforms) The Chosen One – The one to model The Platform Phases The Power of Partition Exchange Loading Data Updates without UPDATE ASM: Performance and Management Made Easy Storage Infrastructure Availability Performance Backup & Recovery Trade Offs Lessons Learned/Tips & Tricks Project . . . → Read More: Designing a 300TB Data Warehouse with ASM Summary In this lesson, you should have learned how to: Identify the benefits of pivoting and unpivoting operations Write crosstab queries to pivot (rotate) column values into new columns and to unpivot (rotate) columns into column values Pivot and unpivot with multiple columns and multiple aggregates Use wildcards and aliases with pivoting operations . . . → Read More: Oracle Database 11g: BI and Data Warehousing Student Guide Materialized Views and Refresh Types This practice will familiarize you with the various features and privileges to ensure successful creation of a materialized view from a base table. 1) Grant the necessary privileges for user Scott to create materialized views and allow query rewrite on the materialized views owned by schema Scott. As user SYSTEM, . . . → Read More: Materialized Views and Dimensions |
|
||||
|
Copyright © 2012 Oracle Clinic – Maclean Liu的个人技术博客 - All Rights Reserved |
|||||
最新评论