Data Warehousing

Data warehousing interview questions

---

<<Previous  Next>>

Define Data warehousing. Describe Data Marts. What is Fact table? Describe ETL process What is SNOW Flake Schema design? Also read Question: What are the steps to process a single SELECT statement? Answer - SQL Server uses the following steps to process a single SELECT statement.... Question: What are the restrictions while creating batches in SQL Server? Answer - CREATE DEFAULT, CREATE PROCEDURE, CREATE RULE, CREATE TRIGGER, and CREATE VIEW statements.... Question: Explain GO Command. Answer - GO Command is used to signal the end of a batch..... Question: What is the significance of NULL value and why should we avoid permitting null values? Answer - Null means no entry has been made. It implies that the value is either unknown or undefined.....