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 is logical data model?

1264

What are normalization, first normal form, second normal form and third normal form?

1117

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1161

What is the purpose of indexes?

1133

What type of indexing mechanism do we need to use for a typical data warehouse?

1233

Can we collect statistics on multiple columns?

1132

How do you create a table with an existing structure of another table with data and with no data?

1 1650

Can you load multiple data files for same target table using fastload?

1 1752

Can you connect multiload from ab initio?

1286

Why does varchar occupy 2 extra bytes?

1277

Why are oltp database designs not generally a good idea for a data warehouse?

1108

What's the difference between timestamp (0) and timestamp (6)?

1259

What do high confidence, low confidence and no confidence mean in explain plan?

1104

How many tables can you join in v2r5?

1121

What are the things to be considered while creating secondary index?

1150

Un-Answered Questions { Data Warehouse }

What is the basic structure of a sas program?

1177

What are logical views used for in microstrategy?

1021

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2109

What formatting can be applied to the information that is sent out by microstrategy narrowcast server?

1046

What are vldb properties?

1072

New coloums are added in database, then how you know in report level

1642

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

2090

How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1136

What is the difference between match merge and one to one merge?

1328

How many sessions of MAX is PE capable of handling at a particular time?

1139

Mention what are the different types of parallelism used in abinitio?

1170

What is a pdv and what are its functions?

1225

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2605

hi my name is siraj i want to know cognos queriy language

2321

what is pmrep command?

2487

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