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

What are the different functions included in the server software?

1091

What are the components provided on node?

1095

What are the design features involved in teradata?

1125

What are the different functions performed in development phase?

1140

What are the uses of client software involved in teradata?

1044

What is the use of virtual processor connectivity in teradata?

1102

What are the uses of bynets in multi-node systems?

1083

What are the steps involved in the process flow of the sql statement through channel attached system?

1169

Describe the differences between a data warehouse and data mart.

1071

Describe a data warehouse.

1035

What is the main difference between star and snowflake star schema? Which one is better and why?

1088

What are situations where snowflake schema is better than star schema when the opposite is true?

1045

What is data cleaning? How can we do that?

1099

What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

1209

What is a cube in data warehousing concept?

1150

Un-Answered Questions { Data Warehouse }

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2278

What is the procedure for creating independent data marts from informatica 7.1?

1129

What is a joint child?

992

What are objects?

1062

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

1044

What is the meaning of Caching in Teradata?

1192

what is flow of project?

2064

What are the scenarios in which full table scans occurs?

1059

Explain datawarehousing?

1122

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2408

can cubes contain measures ?

2084

Differentiate between datastage and informatica?

1253

If a Node is busy what are the steps you can take to avoid ?

2462

What are the differences between datamart vs. Reporting cube?

1175

Can you explain a cognos controller?

1079

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