Chapter 4: BackRoom

Question 1

Backroom is also known as

Answer 1

Data acquisition

Question 2

Back room is defined by

Answer 2

Business requirements

Question 3

Source Systems

Answer 3

-Can be from various places
-can be from legacy systems, report or flat file
-dictates data storage types

Question 4

Data Staging Area

Answer 4

-where data transformation takes place
-DW value is created

Question 5

Data Staging Storage Types

Answer 5

-Flat files, relational tables and proprietary structures
-conformed dimensions are created
-Emergency recovery is stored here

Question 6

Presentation Servers

Answer 6

-stores data for end user queries and reports
-data detail and aggregate data loaded by business segment

Question 7

Data Staging System Requirement

Answer 7

-Productivity Support
-Usability
-Metadata driven

Question 8

Productivity Support

Answer 8

need capabilities to support code library check in and check out, version control and prod & dev system builds

Question 9

Usability

Answer 9

-Increase usability by improving system documentation

Question 10

Metadata driven

Answer 10

Information about tables should be accessible

Question 11

Extract Services

Answer 11

-pulling data from the source systems
-60% of development time is spent in the extract process
-Challenge what data to pull and filters to apply
-

Question 12

Major Extract Requirements

Answer 12

• Multiple sources
  -Code generation
  -Multiple extract types
  -replication
  -compression/decompression

Question 13

Multiple extract Types

Answer 13

-Incremental Loads
-Transaction Events
-Full Refresh

Question 14

Replication

Answer 14

continually updating the tables during the day

Question 15

Incremental Loads

Answer 15

Use date of the last load as metadata

Question 16

Transaction events

Answer 16

use transaction log file to identify changed records

Question 17

Full Refresh

Answer 17

Pulling entire tables instead of pulling solely the changes

Question 18

Data transformation Services

Answer 18

Transforming the data into a presentable format for the end users

Question 19

Transformation abilitites

Answer 19

-Cleansing, Deduping, Merging
-Data Type Conversion

Question 20

Data Loading Services

Answer 20

-Function of the target platform

Question 21

Asset Management : Back Up and Recovery

Answer 21

Process to facilitate the return of the DW in case of system failure

Question 22

What does Back up system need?

Answer 22

-High performance
-Simple administration
-Automated Lights-out operations-

Question 23

archive and retrieval

Answer 23

-Process allowing users to retrieve older data
-it reduces expenses by using inexpensive media
-Dictating how long data should be kept before archiving
-Better solution to archive data during load process

Question 24

Backup and Archive Planning

Answer 24

1. Start with a backup plan
2. Determine an appropriate backup process
3. Implement the process
4. Practice

Question 25

Extract and load Security Issues

Answer 25

-Security more critical in from room
-Bulk data movement should be secured using firewalls
-what access should be granted