Level of Granularity of a fact table
Write down the level of Granularity of a fact table?
Expert
The granularity is the lowly level of information stored up in the fact table. The depth of data level is named as granularity. In date dimension the level could be quarter, month, year, period, day, week of granularity. The procedure consists of the two steps which are illustrated below:
Briefly describe the foreign key columns in dimension table and fact table?
Illustrates the term data sparsity and how this effect upon aggregation?
Illustrates a stored procedure?
Explain the term operational data stage (ODS) and data warehouse?
Explain the way to swap a db device along with other.
Describe briefly the term SQL Server Analysis Services cubes?
Write down the snapshot with reference to data warehouse?
Write down a short note on the difference between two and three-tier architectures?
Explain the Scope of Analysis?
Elucidate briefly what is batch and also give explanation about the types of batches?
18,76,764
1947449 Asked
3,689
Active Tutors
1454872
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!