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 the difference between data ware house & data mart?

1024

After the complete generation of a report who will test the report and who will analyze it?

1046

What is the difference between snowflake and star schema?

1108

Explain the importance of data warehouse?

1073

How can we run the graph? What is the procedure for that?

1007

What is a source qualifier?

1169

How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

1039

After the generation of a report to whom we have to deploy or what we do after the completion of a report?

962

What is difference between e-r modeling and dimensional modeling?

974

What is a hash cluster?

1054

What is data analysis? Where it will be used?

1053

What are the methodologies of data warehousing?

1045

What is the difference between dependent data warehouse and independent data warehouse?

1060

What is the difference between aggregate table and materialized view?

1151

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1480

Un-Answered Questions { Data Warehouse }

What do you mean incremental aggregation?

1135

What is initial load and what is full load?

1066

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3647

Explain usage analysis in datastage?

1231

Explain how to schedule the report in b.o?

1130

What is drill-through?

1051

Give some information on report bursting?

1056

What are all the problems you faced while validating tables and reports?

3515

How to limit the max no of rows retrieved in the report?

1044

Is it possible to join multiple Databases in a Catalog?

1171

What does the RUN statement do?

1360

Parameter and variable differences

2117

What is the purpose of interprocessor stage in server jobs?

2300

sed,awk,head

1514

What are the functions of a teradata dba?

1135

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