Introduction of the term non-additive facts
Give a brief introduction of the term non-additive facts?
Expert
The facts which can’t be summed up for the dimensions there in the fact table are named as non-additive facts . The facts can be functional if there are alters in dimensions. For illustration, profit margin is a non-additive fact for it has no importance to add them up for the account level or day level.
Illustrate the term data mart. What do you mean by it?
Illustrates the data structures used to do recursion?
Write down the latest error handling technique in SQL Server 2005?
Provide the formula for the Pearson’s r.
Explain Triggers and Rules?
Briefly describe the employ of aggregate tables and lookup tables?
Give a brief introduction of term the conformed fact?
Explain the command line functions which export and import the DS jobs?
States the term Global temporary.
Explain the procedure through which an end-user can share user objects with other users?
18,76,764
1937090 Asked
3,689
Active Tutors
1442783
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!