Data Warehouse General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Warehouse General Interview Questions

Questions Answers Views Company eMail

What are the different models used in cluster analysis?

920

Why facts table is useful in representing the data?

957

What is the use of dimensional modeling in data warehousing?

940

What is the function of surrogate key in data warehousing?

1019

Why is chameleon method used in data warehouse?

1130

Why is dimensional normalization not required?

1062

What are the different ways to represent the loading of dimension tables?

896

What is the difference between data warehouse and operational systems?

1093

What are the stages that are required in data warehousing?

915

What are the steps involved in designing a fact table?

860

Describe the differences between a data warehouse and data mart.

955

Describe a data warehouse.

936

What is the main difference between star and snowflake star schema? Which one is better and why?

994

What are situations where snowflake schema is better than star schema when the opposite is true?

947

What is data cleaning? How can we do that?

1012

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Difference between cold fusion 5 and cold fusion mx 6?

953

What is the difference between Datawarehouse and OLAP?

901

What are components of reportnet?

1046

How to create context?

971

How to add a number to a macro variable?

954

How can we run the graph? How can we schedule the graph in unix?

907

What is the main difference between star and snowflake star schema? Which one is better and why?

994

What is an error log table in informatica occurs and how to maintain it in mapping?

929

Which columns go to the fact table and which columns go the dimension table?

935

Explain what is the main difference between inmon and kimball philosophies of data warehousing?

941

What is the extension of file to save template?

978

What is vdl (view definition language) explain?

1002

What is the difference between mapping parameter & mapping variable in data warehousing?

945

What are parallel querys and query hints?

2191

Define data warehouse?

988

For More Un-Answered { Data Warehouse General } Questions Click Here