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 is the difference between constraind base load ordering and target load plan?

1156

How to add a number to a macro variable?

1047

What is the difference between drill through and masterdetail reports?

1241

What is the difference between narmal load and bulk load?

1 1470

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

1018

What is the use of tabular model, tabular sql, tabular reference in real time application?

1012

How many types of facts and what are they?

1057

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

1104

Why we use repository connectivity?

1029

The same tier?

1141

What is recovering sessions?

997

How to define a cube??

992

What is prompt types of prompts?use of prompts syntax of prompt?

1431

How to drill through from a powerplay cube to reportnet?

990

What is load manager?

1108

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is metadata in context of a datawarehouse and how it is important?

1092

what is difference between drill & scope of analysis?

1168

What is the difference between star and snowflake schemas?

1317

In a star schema, are foreign key constraints between facts and dimensions neccessary?

1035

Describe the differences between a data warehouse and data mart.

1063

Explain what does level of granularity of a fact table signify?

1000

What is a core dimension?

1115

What is mean by aggregate aware?

1155

Can we take backup when the database is opened?

1095

How can we load the time dimension?

1250

Explain degenerate dimension table?

1101

Explain functional dependency?

1137

How do you define data block size?

1101

What is a view as it relates to system modeling?

1031

What is dimension modeling?

1179

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