How many types of facts and what are they?
Submitted by: AdministratorFactless Facts:Facts without any measures.
Additive Facts:Fact data that can be additive/aggregative.
Non-Additive facts: Facts that are result of non-additon
Semi-Additive Facts: Only few colums data can be added.
Periodic Facts: That stores only one row per transaction that happend over a period of time.
Accumulating Fact: stores row for entire lifetime of event.
There are three types of facts
1)Additive fact:a fact which can be summarized by any one of dimension or all dimensions EX:QTY,REVENUE
2)Semi additive fact:a fact which can be summarized for few dimensions not for all dimensions. ex:current balance
3)non additive fact: a fact which cannot be summarized by any of dimensions.ex:percentage of profit
Submitted by: Administrator
Additive Facts:Fact data that can be additive/aggregative.
Non-Additive facts: Facts that are result of non-additon
Semi-Additive Facts: Only few colums data can be added.
Periodic Facts: That stores only one row per transaction that happend over a period of time.
Accumulating Fact: stores row for entire lifetime of event.
There are three types of facts
1)Additive fact:a fact which can be summarized by any one of dimension or all dimensions EX:QTY,REVENUE
2)Semi additive fact:a fact which can be summarized for few dimensions not for all dimensions. ex:current balance
3)non additive fact: a fact which cannot be summarized by any of dimensions.ex:percentage of profit
Submitted by: Administrator
Read Online Informatica Data Warehousing Job Interview Questions And Answers
Top Informatica Data Warehousing Questions
☺ | Explain What is batch and describe about types of batches? |
☺ | Explain How to import oracle sequence into Informatica? |
☺ | Explain How many types of dimensions are available in Informatica? |
☺ | What is the difference between informatics 7x and 8x and what is latest version? |
☺ | How to do unit testing in informatica? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |