Different methods of loading Dimension tables
Describe briefly the different methods of loading Dimension tables?
Expert
The methods to load Dimension tables are illustrated below:
i) Conventional load :- in this the data is determined for any table constraints ere loading.
ii) Direct or Faster load :- The data is straightly loaded with no checking for any constraints.
Illustrates the case statement present into stored procedure?
Explain Triggers and Rules?
Explain what is meant by the term stored procedures?
How would the developer describe variable by using referential data types?
Distinguish between the query answering and direct query answering.
Write down the purpose of Fact-less Fact Table?
Illustrate the term data mart. What do you mean by it?
Give a brief introduction of the term Dimensional Modeling?
Explain Data Only Page Locking in Sybase.
Explain some of the data mining tools.
18,76,764
1960814 Asked
3,689
Active Tutors
1431904
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!