A star schema is the simplest style of data warehouse schema. A star schema consists of one or more fact tables referencing any number of dimension tables. A fact table holds the main data; a dimension table contains attributes that describe data in the fact table.
In this cue card set we use a very simple star schema consisting of one fact table SH.SALES
and one dimension table SH.CUSTOMERS
.
These cue cards show how you can use Data Miner to prepare data stored in a star schema so that the data can be mined.
This cue card set shows how to:
The workflow builds classification models to predict customer gender based on sales history.
Launch the cue cards to learn how to aggregate data in a table and join tables.
Copyright © 2011, 2012, Oracle. All rights reserved.