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?

1123

How to add a number to a macro variable?

998

What is the difference between drill through and masterdetail reports?

1169

What is the difference between narmal load and bulk load?

1 1414

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

951

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

968

How many types of facts and what are they?

1018

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?

1060

Why we use repository connectivity?

985

The same tier?

1064

What is recovering sessions?

941

How to define a cube??

936

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

1349

How to drill through from a powerplay cube to reportnet?

939

What is load manager?

1056

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Where the cache files stored?

1018

Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?

1230

Explain what are components of reportnet?

978

Explain grouped cross tab?

2632

Explain differences between star and snowflake schemas?

1163

What is Star Schema?

1114

What is load manager?

1056

Explain some of modeling tools available in the market?

968

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

1022

Why fact table is in a normal form?

997

Code the tables statement for a single-level (most common) frequency?

939

What is "method/1"?

1071

Fact table is in normalized or de-normalized form?

969

Where do we use semi and non additive facts?

994

what is parallel query?

2092

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