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.
Explain all the types of Jobs you developed?
Define the term File Manager and Storage Manager in relational database management system.
Explain the types of views within Data stage Director?
Briefly describe the differentiation between data warehouse and OLAP?
Write down the unsupported repository objects for mapplet?
Explain metrics folders in brief?
Explain the term precision in Data Structures? Answer: Precision considers as to the accuracy of the decimal portion of a value. It is the number of digits permitted
Explain the term lattice of cuboids in brief.
Describe briefly the term recursive relationship? Comprise an appropriate example?
Explain the term Coalesce. Answer: Coalesce is also obtainable in Sybase, this function estimates the listed expressions and returns the first non-null value.
18,76,764
1960169 Asked
3,689
Active Tutors
1434481
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!