Different Types of facts
Illustrate the different Types of facts?
Expert
There exist three types of facts:
a) Additive : Additive facts are the facts which may be summed up through all of the dimensions within the fact table.
b) Semi–Additive : are the facts which may be summed up for some of the dimensions within the fact table, but not the others.
c) Non–Additive : are the facts which cannot be summed up for any of the dimensions present within the fact table.
Explain the object qualification?
Briefly describe the differentiation between data warehouse and OLAP?
How to produce an Auto Incremental Number within a SSIS Package?
Give a brief introduction of the term BUS Schema?
Explain the types of jobs we have within the Data stage?
Write down a short note on the difference between an ERD and EER.
Explain how the Chasm trap is solved?
Give a brief introduction of the term analysis service?
Write down the differentiation between Power Center and Power Mart?
Write down the brief note on the differentiations between Normalizer and Normalizer transformation?
18,76,764
1923087 Asked
3,689
Active Tutors
1417705
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!