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

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

Explain a linked cube?

961

Explain what are the methodologies of data warehousing?

928

Where we use surrogate key explain with example?

1139

Explain difference between snow flake and star schema.

1056

Difference between e-r modeling and dimentional modeling?

941

Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1036

Explain what are the different types of data warehousing?

964

Explain what are the advantages data mining over traditional approaches?

1165

Explain er diagram?

999

Explain what are the vaious etl tools in the market?

944

Explain what are the steps to build the data warehouse?

953

What are the data marts?

984

Explain conformed fact?

975

Explain the difference between view and materialized view?

948

What are the vaious etl tools in the market?

1 2442

Un-Answered Questions { Data Warehouse }

What are the steps to be taken to schedule the report?

966

How to provide security in frame work manager for a query subject?

963

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

2004

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2041

Can you define a query subject?

1022

Why we use repository connectivity?

986

It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

2444

What is pass through metrics in microstrategy?

984

How to implement security measures using repository manager?

1184

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2129

What are fundamental stages of data warehousing?

1046

How to calculate fact table granularity?

1024

What is the profile and package?

2303

What is an object prompt?

1034

How identifying bottlenecks in various components of informatica and resolving them?

1137

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