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?

958

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

984

What is the difference between snowflake and star schema?

1050

Explain the importance of data warehouse?

1013

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

946

What is a source qualifier?

1104

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?

981

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

911

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

924

What is a hash cluster?

983

What is data analysis? Where it will be used?

986

What are the methodologies of data warehousing?

992

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

1007

What is the difference between aggregate table and materialized view?

1100

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

1387

Un-Answered Questions { Data Warehouse }

Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.

1376

Define filter transformation?

1098

What is authentication? How many types of authentication.

915

What are the types of data warehouses?

1526

Explain sessions. Explain how batches are used to combine executions?

1034

How we can monitor the performance of Redshift data warehouse cluster.

What are prompted filters?

931

How substr function works in sas?

1222

What is pmcmd command?

1123

What is tracing level?

1068

Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?

1012

Explain what is redshift?

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1082

What is the difference between ods and oltp?

1021

How would you find out whether a sql query is using the indices you expect?

1070

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