DataWarehouse Concepts subpart-2 - ETL- iNFORMATICA DEVELOPER

Sunday, May 19, 2019

DataWarehouse Concepts subpart-2

ktnewslive

1- Subject Oriented




Data is Integrated and Loaded by Subject




2-Time Variant

Operational System

Data Warehouse

View of The Business Today

Designated Time Frame (3 - 10 Years)

Operational Time Frame

One Snapshot Per Cycle

Key Need Not Have Date

Key Includes Date




3- Integrated

Order Processing
Order ID = 10

      D/W
Accounts Receivable
Order ID = 12

Order ID = 16
Product Management
Order ID =  8




HR System
Sex = M/F

     D/W
Payroll
Sex =  1/2

Sex = M/F
Product Management



4-Non - Volatile


Sex =  0/1




7 comments: