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.
How can we increase the performance within the Data Stage?
Why Increase correct timeslice -201?
Why recursive relationships are not good? How do you solve them?
Explain the repository domains?
Explain the Aggregate Awareness?
Describe the difference between differential backups and SQL Server 2000 complete?
Explain what is meant by the Drill up/down/by/through?
Illustrate the use and application of the DB Miner.
How must you modify the function to handle error?
Describe briefly the ‘paradigm mismatch’ among SQL and application programming languages.
18,76,764
1947870 Asked
3,689
Active Tutors
1414706
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!