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.
Elucidate what are the tasks which Load manger process will do?
Specify the options in the target session of the update strategy transformation?
Give a brief introduction of the term critical column?
Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?
Illustrates the Radix Sort?
Specify the user profiles within the Supervisor?
Briefly describe the foreign key columns in dimension table and fact table?
What types of tables derived from the ERD?
Write down a short note on the difference between partial specialization and total specialization.
Elucidate briefly power center repository?
18,76,764
1935174 Asked
3,689
Active Tutors
1429201
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!