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 term transformer stage?
Specify the various methods through which we may link the universes?
Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?
Illustrate the term indexing. Specify the kinds of the indexing.
Explain Batches and Session?
Illustrate why informational and operational systems are separate?
Write a short note on the differences between vertical and horizontal portioning?
Explain the uses of stored procedure?
When two relational tables is connected to SQ Trans, what are the probable errors it will be thrown?
Describe briefly the difference between pessimistic locking and optimistic locking?
18,76,764
1954625 Asked
3,689
Active Tutors
1434009
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!