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?

1210

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

1059

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

1100

What is the purpose of indexes?

1080

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

1169

Can we collect statistics on multiple columns?

1069

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

1 1591

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

1 1686

Can you connect multiload from ab initio?

1225

Why does varchar occupy 2 extra bytes?

1201

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

1059

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

1200

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

1048

How many tables can you join in v2r5?

1075

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

1101

Un-Answered Questions { Data Warehouse }

differentiate between two-tier, three-tier and four-tier connections.

995

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1113

How do you load only null records into target?

1220

Copy ".roi" file of management console to another path of management console's folder using ".rox" file. or any command of actuate. Is it Possible? if Yes then pls give me Example.

2931

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

1059

What is partitioning? What are the types of partitioning?

1172

What are the steps to create a data model?

1061

What is the difference between set functions and filter function in dimensional data?

2918

What are the benefits of data analyzing?

1191

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1105

What are steps we have to follow in designing the userfriendly universe?

980

what is the difference between cardinality and Nullability?

3458

What would you change about your job?

2391

What are the data marts?

984

What is the function of aggregator transformation?

1088

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