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 are the types of prompt?
Write about the term Attribute, Entity and Relationship?
Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?
What is Enterprise Resource Planning (or ERP), and what type of a database is employed in an ERP application?
Why do normalized tables need more complex SQL when SQL statements are employed in application programs?
Explain the repository domains?
Explain different domain which is there in BO?
Illustrates the NetLib for Clipper? Answer: It is a multi-faceted networking library for CA-Clipper. While this focuses upon network functionality this also have man
Illustrates the levels of data abstraction?
Illustrates the difference between a user’s defined function and a stored procedure?
18,76,764
1939523 Asked
3,689
Active Tutors
1459933
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!