Tag: technology

Transaction processing system

Decision support system

Executive information system

Management information system

Expensive transaction Ledger

Extract Transaction Load

External Table Load

Extraction Transformation Load

Facts has the measure and dimension have attributes

Facts are the slowly changing and dimensions are constantly changing

Fact are less in size and dimensions are more in size

None of the above

Amount of data stays about the same over time

Data are scattered through out organization

Decreasing amount of external data needs to be considered

Data security is easily compromised

Organized mainly hieratically.

Processed in distributed fashion

Organized for end users

Are non routine and do not recur often

Are organized by end users

Are coded consistently

Are updated in real time

Are organized in a hierarchical structure

Subset of an organizational data store

Usually oriented to a specific purpose or major data subject

Are analytical data stores designed to focus on specific business functions

All of the above

0%

10%

50%

90%

100%

Against applications

Against events

Against groups

Against users

Application

Folder

Resource

User