Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Friday, 19 July 2013

Types of Fact Tables in Datawarehouse

By on 08:47:00

There are 3 types of fact tables in data warehouse

1. Transactional 

2. Periodic Snapshot

3. Accumulating  snapshot

Transactional Fact Table: 

1. Transactional fact table will be in detailed level.

2. It will have each line of transaction. Example: each line of sale and invoice.

3. Transactional fact table has so detailed level data, so it will be have all the dimensional assisted with it

Periodic Snapshot Fact table:

1. Periodic snapshot fact table will have information by time to time.

2. Consider you want  the information of growth of sales  information of an organisation for a particular region last month compare to this month. Then you will need  periodic snapshot fact table.

3. Periodic snapshot fact table will depend upon transactional fact table as it need a detail held in transactional fact table related to region sales of an organisation.

Accumulating  snapshot Fact table:

1. Accumaulating snapshot fact table is used to show the information of the business which has cleary defined from begin to the end.

2. If you see a purschase order of an organisation, The purschase will move in specific order unstill it is fully processed.

3. Accumlating snapshot fact table will have multiple date column, each date column represent the level of purshase status of an organisation.

How you will define the fact table?

1. Identify the business process of an orginaization

2. Define the grain

3. choose the dimensional for your fact table


Post a Comment

Blog Archive


1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA (1) OBIA (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)