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.
What is meant by the Drill Through?
Name the areas where data structures are applied broadly?
Describe any two reasons which show the necessity of database redesign?
Explain the object qualification?
Write down the security level employed in BO?
Illustrates the term update statistics in Sybase?
Explain the Aggregator Transformation?
Describe why XML is a better markup language than HTML?
Describe briefly the difference between a shared lock and an exclusive lock?
Explain, what are Dimensional table?
18,76,764
1944493 Asked
3,689
Active Tutors
1425440
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!