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 about dirty dimension?

1173

What is drilling across?

994

What are the different types of segments?

991

Explain the hierarchies level data warehousing.

885

What is the difference between junk dimension and degenerated dimension?

1136

What are data modeling and data mining? Where it will be used?

989

How much data hold in one universe.

994

What are the differences between star and snowflake schema?

1106

What is the data type of the surrogate key?

1005

How can you implement many relations in star schema model?

1001

How can you import tables from a database?

1085

What are the different types of data warehousing?

957

What is the main difference between inmon and kimball philosophies of data warehousing?

1116

What is data analysis?

959

What is core dimension?

1061

Un-Answered Questions { Data Warehouse }

What is decode in informatica?

1163

What is Data Caches size?

1091

What is analytical or analytic mean?

1127

What is the use of %include statement?

1062

Which lifecycle we will use for reporting?

974

How many project sources we can create in metadata?

1091

For what purpose would you use the RETAIN statement?

1524

What are the different uses of a repository manager?

1100

what is the output when -1 is put in select_expr of FBE?

1406

what are sas/access and sas/connect? : Sas programming

993

What are the data types present in bo?

1128

What is level prompt?

959

Explain the data types present in bo and what happens if we implement view in the designer and report?

1029

what is the difference between nodup and nodupkey options? : Sas programming

1192

What do you mean incremental aggregation?

1076

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