What is fact?

Question

What is fact?

Accepted Answer

A fact is a piece of information that is known to be true or proven through evidence.

Facts are objective and can be verified through research or observation.
Facts are not opinions or beliefs.
Examples of facts include the boiling point of water, the population of a city, and historical events that have been documented.
Facts can be used to support arguments or conclusions.
Facts can change over time as new information is discovered or theories are revised.

Accepted Answer

Fact Table:

 These are nothing but the fact or measures or summarized data about the business.

 It is having foreign key.

 It contains numeric values.

Types of Fact Table:

1. Additive Fact Table:

 In which the fact value is generated by considering all dimension tables.

 Ex: sales

2. Semi – Additive Fact Table:

 In which fact value is generated by considering few dimension tables.

 Ex: quantity in hand (balance quantity), bank balance.

3. Non – Additive Fact Table:

 In which fact value is generated without considering any dimension table.

 Ex: sales tax, unit price.

4. Fact-Less Fact Table:

 It does not contain any fact or measure.

 It contains foreign keys.

Top Cognizant ETL Tester interview questions & answers