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

Where the data cube technology is used?

960

What are data modeling and data mining?

1086

What is surrogate key? Explain with examples.

1158

What is junk dimension? What is the difference between junk dimension and degenerated dimension?

1061

What is a real-time data warehouse?

998

Can any one explain about core dimension, balanced dimension, and dirty dimension?

1056

How do you define data block size?

1048

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

1072

What are the possible data marts in retail sales?

998

What is informatica architecture?

1065

What is a real-time data warehouse? How is it different from near to real-time data warehouse?

959

explain about balanced dimension,

983

Briefly state different between data ware house & data mart?

1050

What is an error log table in informatica occurs and how to maintain it in mapping?

966

Explain batch processing in ab initio?

1458

Un-Answered Questions { Data Warehouse }

When do we go for the tools in the market?

947

I generated one report design time I can color green. At run I want bule how to change dynamically? And which method I can over write?

986

What are the data types present in bo?

1129

What is static and local variable?

1036

what are all the reports you generated in your recent project?

2199

What is target load order?

1248

Hi, If anyone has base SAS certification dumps, please share.

1868

what are the special features in cognos reportnet?

1061

What are the different types of sas functions?

1285

What does level of granularity of a fact table signify?

1095

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

2048

What is oci?

1302

What is a Framework manager?

1048

Mention few advantages of router transformation over filter transformation.

1023

How do you verify a complicated sql?

1067

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