⟩ Explain If data is partitioned in your job on key 1 and then you aggregate on key 2, what issues could arise?
Data will partitioned on both the keys ! hardly it will take more for execution .
Data will partitioned on both the keys ! hardly it will take more for execution .
Explain what are the different models used in cluster analysis?
Tell me how many fact tables are there in a star schema?
Explain what is the difference between OLTP and OLAP?
Explain what is the very basic difference between data warehouse and operational databases?
Explain me what is Normalization?
Tell me what are the steps involved in designing a fact table?
Tell me why is Business Intelligence (BI) important in data warehousing?
Define me a warehouse manager?
Tell me what is dimension?
Explain me how does a Data Cube help?