The Optimizer chooses Cost based approach and optimizes with the goal of best throughput if statistics for at least one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE based approach.
Explain What are slowly changing dimensions?
What are modeling tools available in the Market?
Explain Which columns go to the fact table and which columns go the dimension table?
What are the advantages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs?
Explain me what are conformed dimensions?
Explain Why are OLTP database designs not generally a good idea for a Data Warehouse?
What is data mining?
Explain What does level of Granularity of a fact table signify?
How to load the time dimension?
Explain What are non-additive facts?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
