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 what is meant by the Drill up/down/by/through?
Explain Batches and Session?
Give definition of data structure?
Define the term DataStage?
Describe how operation is carried out within the spiral method?
What is Enterprise Resource Planning (or ERP), and what type of a database is employed in an ERP application?
Illustrates the benefits of running stored procedure upon a database engine?
In JDBC driver which coding pattern is use? Describe briefly?
What is BCA? Discuss its features?
Distinguish between the query answering and direct query answering.
18,76,764
1926584 Asked
3,689
Active Tutors
1442747
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!