Match the given terms and definition. ___ periodic data _ data mart _ star schema _ grain _ reconciled data _ dependent data mart _ real-time data warehouse _ transient data ___ snowflake schema a. lost previous data content b. detailed historical data c. data not altered or deleted d. data warehouse of limited scope e. dimension and fact tables f. level of detail in a fact table g. data filled from a data warehouse h. structure that results from hierarchical dimensions i. a warehouse that accepts near real-time feeds of data

Question

Want to see the full answer?

Answer 1

Question

Chapter 9, Problem 9.2RQ

Program Plan Intro

Match the given terms and definition.

___ periodic data

_ data mart

_ star schema

_ grain

_ reconciled data

_ dependent data mart

_ real-time data warehouse

_ transient data

___ snowflake schema

a. lost previous data content

b. detailed historical data

c. data not altered or deleted

d. data warehouse of limited scope

e. dimension and fact tables

f. level of detail in a fact table

g. data filled from a data warehouse

h. structure that results from hierarchical dimensions

i. a warehouse that accepts near real-time feeds of data

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 2

Question

Chapter 9, Problem 9.2RQ

Program Plan Intro

Match the given terms and definition.

___ periodic data

_ data mart

_ star schema

_ grain

_ reconciled data

_ dependent data mart

_ real-time data warehouse

_ transient data

___ snowflake schema

a. lost previous data content

b. detailed historical data

c. data not altered or deleted

d. data warehouse of limited scope

e. dimension and fact tables

f. level of detail in a fact table

g. data filled from a data warehouse

h. structure that results from hierarchical dimensions

i. a warehouse that accepts near real-time feeds of data

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Question

Chapter 9, Problem 9.2RQ

Program Plan Intro

Match the given terms and definition.

___ periodic data

_ data mart

_ star schema

_ grain

_ reconciled data

_ dependent data mart

_ real-time data warehouse

_ transient data

___ snowflake schema

a. lost previous data content

b. detailed historical data

c. data not altered or deleted

d. data warehouse of limited scope

e. dimension and fact tables

f. level of detail in a fact table

g. data filled from a data warehouse

h. structure that results from hierarchical dimensions

i. a warehouse that accepts near real-time feeds of data

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Question

Chapter 9, Problem 9.2RQ

Program Plan Intro

Match the given terms and definition.

___ periodic data

_ data mart

_ star schema

_ grain

_ reconciled data

_ dependent data mart

_ real-time data warehouse

_ transient data

___ snowflake schema

a. lost previous data content

b. detailed historical data

c. data not altered or deleted

d. data warehouse of limited scope

e. dimension and fact tables

f. level of detail in a fact table

g. data filled from a data warehouse

h. structure that results from hierarchical dimensions

i. a warehouse that accepts near real-time feeds of data

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Chapter 9, Problem 9.2RQ

Program Plan Intro

Match the given terms and definition.

___ periodic data

_ data mart

_ star schema

_ grain

_ reconciled data

_ dependent data mart

_ real-time data warehouse

_ transient data

___ snowflake schema

a. lost previous data content

b. detailed historical data

c. data not altered or deleted

d. data warehouse of limited scope

e. dimension and fact tables

f. level of detail in a fact table

g. data filled from a data warehouse

h. structure that results from hierarchical dimensions

i. a warehouse that accepts near real-time feeds of data

Answer 6

Chapter 9, Problem 9.2RQ

Program Plan Intro

Match the given terms and definition.

___ periodic data

_ data mart

_ star schema

_ grain

_ reconciled data

_ dependent data mart

_ real-time data warehouse

_ transient data

___ snowflake schema

a. lost previous data content

b. detailed historical data

c. data not altered or deleted

d. data warehouse of limited scope

e. dimension and fact tables

f. level of detail in a fact table

g. data filled from a data warehouse

h. structure that results from hierarchical dimensions

i. a warehouse that accepts near real-time feeds of data

Answer 7

Chapter 9, Problem 9.2RQ

Program Plan Intro

Match the given terms and definition.

___ periodic data

_ data mart

_ star schema

_ grain

_ reconciled data

_ dependent data mart

_ real-time data warehouse

_ transient data

___ snowflake schema

a. lost previous data content

b. detailed historical data

c. data not altered or deleted

d. data warehouse of limited scope

e. dimension and fact tables

f. level of detail in a fact table

g. data filled from a data warehouse

h. structure that results from hierarchical dimensions

i. a warehouse that accepts near real-time feeds of data

Answer 8

Expert Solution & Answer

Answer 9

Expert Solution & Answer

Answer 10

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 11

Ch. 9 - Prob. 9.1RQ Ch. 9 - Prob. 9.2RQ Ch. 9 - Prob. 9.3RQ Ch. 9 - List the five major trends that necessitate data...Ch. 9 - Prob. 9.5RQ Ch. 9 - Prob. 9.6RQ Ch. 9 - Prob. 9.7RQ Ch. 9 - Prob. 9.8RQ Ch. 9 - Prob. 9.9RQ Ch. 9 - Prob. 9.10RQ

Want to see the full answer?

Chapter 9 Solutions