Home
Flashcards
Preview
Day 3
Home
Get App
Take Quiz
Create
What are the high level uses for MS Architect?
Initially populate the MetaData (Project Definitions and Parameters)
Create Schema Objects
What are the 4 Types of Schema Objects? (In order of creation workflow)
Tables
Facts
Attributes
Hierarchies
What are the 4 Aspects of the Project Design Process?
Design the Logical Data Model
Design the DataWarehouse Schema
Create the Project in MS Architect
Manage the Project Schema
What is a Logical Data Model and its 3 parts?
A diagram that shows the information you want to analyze and its relations to one another.
It's made up of:
Facts
Attributes
Hierarchies
What are Attribute Forms?
Different ways of identifying the same Attribute (like Name, SSN, email, etc)
What 3 Factors should be considered when creating a Logical Data Model?
User Reporting Requirements
Existing Data Sources
Technical and Performance considerations
What are the 5 steps to creating a Logical Data Model?
List all information that will be used in reporting
Identify which are facts
Identify which are Attributes
Determine the relationships between attributes
Organize Attributes into Hierarchies
What are the 3 column types in a DataWarehouse Schema?
ID
Description
Fact
What are the 4 types of Tables in a DataWarehouse Schema?
Normalized
Moderately DeNormalized
Completely DeNormalized
Star Schema
What 4 Factors should be considered in designing the DataWarehouse Schema?
User Reporting Requirements
Query Performance
Data Volume
Database Maintenance
What are the 4 steps to Project Creation?
Configuring the Project MetaData
Configuring the Project Connectivity
Creating the Neccesary Schema Objects
Updating the Project Schema
What are the two tools used in Project Creation?
Connectivity Configuration Wizard (Creates the DSNs)
Configuration Wizards
What are the 3 steps to creating the project MetaData
Create and Empty MetaData Database
Create a DSN (Data Source Name) to connect
Create the MetaData shell
What is the structure of Project Connectivity?
Project Source -> MetaData
Project Source -> Project -> Database Instance -> Database Connection -> Data Warehouse
What are the 3 ways of creating Schema Objects?
Project Creation Assistant (This is the only way to create the project itself)
Schema Object Editors
Architect Graphical Interface
What are the 5 things the Project Creating Assistant lets you do?
Create Project
Select Tables from Warehouse Catalog
Create Facts
Create Attributes
Open Architect Graphical Interface
What are the 4 Object Editors available?
Attribute Editor
Fact Editor
Hierarchy Editor
Logical Table Editor
Author
mcharliem
ID
29627
Card Set
Day 3
Description
Day 3
Updated
2010-08-11T19:38:18Z
Home
Flashcards
Preview