Day 3

Home

Get App

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

29627

Card Set

Day 3

Description

Day 3

Updated

2010-08-11T19:38:18Z

Show Answers