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 various extensions for stored procedures?
What is BCA? Discuss its features?
What do you understand by the term concurrency control in DBMS?
Explain the master/detail reports?
Define the term Smoothing.
Explain all the types of Jobs you developed?
Illustrate the term data mart. What do you mean by it?
Explain Triggers and Rules?
Explain offline /online modes in the Designer?
What do you understand by the termed dependency graph in DBMS?
18,76,764
1952029 Asked
3,689
Active Tutors
1440991
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!