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?

907

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

940

What is the difference between snowflake and star schema?

1008

Explain the importance of data warehouse?

959

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

901

What is a source qualifier?

1046

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?

947

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

869

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

879

What is a hash cluster?

944

What is data analysis? Where it will be used?

937

What are the methodologies of data warehousing?

944

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

946

What is the difference between aggregate table and materialized view?

1048

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

1328

Un-Answered Questions { Data Warehouse }

how to read the variables in sas? : Sas-administrator

979

whom do you report?

1891

What is data caches/ index caches?

1041

Can you explain engine tier in information server?

1081

What are the ways to do a “table lookup” in sas?

991

how to create user defined function (udf) in informatica

1268

how many maximum session supports to multiload in teradata ??

2063

r u done any partitions in ur project?

1771

Implementation methodology

1667

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2688

Explain what are the vaious etl tools in the market?

890

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1468

What do you know about sas and what we do? : sas-grid-administration

1078

From where u get the logical query of your request?

745

Which columns go to the fact table and which columns go the dimension table?

932

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