Pages
(Move to ...)
Home
Oracle 12c
Oracle 11g
PL/SQL
MySQL
Data Warehousing
SQL Server
Data Analytics
Big Data
NoSQL
About
▼
Showing posts with label
Data Warehouse
.
Show all posts
Showing posts with label
Data Warehouse
.
Show all posts
Data Warehouse: Concepts on ETL Processes (Pivoting) (II)
›
Transforming presentation: What is a Pivoting operation ? It is a key technique in DWH: allow you to transform multiple rows of...
Data Warehouse: Concepts on ETL Processes (Transforming)
›
Data Warehouse: Four (4) typical transformation and loading scenarios (a) Key Lookup Scenario (b) Business Rule Violation Sce...
1 comment:
Data Warehouse with Oracle Data Integrator (ODI) (II)
›
The need for automated integration solutions Challenges to data integration: Terabytes to Pentabytes of data Fenomenal data explosi...
Data Warehouse with Oracle Data Integrator (ODI)
›
Building a Data Warehouse: typical steps and milestones Research and specify business needs ( Key Indicators ) Identify data sourc...
1 comment:
Oracle On-line Analytic Processing (OLAP) (I)
›
OLAP Cubes can play three (3) roles in an Oracle Installation: (a) Full-featured, fully integrated multidimensional server Appl...
Using Oracle External Tables
›
External tables do not reside in the database, and can be in any format for which an access driver is provided. You can select , join ...
Data Warehouse: Basic Concepts (I)
›
@Amazon Common requirements of Data Warehouse systems Must provide easy access to the organization's information Show consist...
›
Home
View web version
