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 an ETL or ETT? And what are the different types?

7500

how do u extract data from different data sources explain with an example?

2254

what are the reporting tools and difference between them?

2097

how do u automate Extraction process?

1 4819

without using ETL tool can u prepare a Data warehousing and maintaining?

3 8158

how do u identify the changed records in operational data?

QualTech,

2535

what is SMP AND MPP?

8 64509

what are the facilities provided by data warehouse to analytical users?

2085

what are the facilities provided by OLAP to analytical users?

1 4728

what is HISTOGRAM? how to generate statistics?

1 5020

how do u set the size of block buffer?

1 4418

how do u implement unconn.stored proc. in a mapping?

1 4922

if u can't find what you are looking for in lookup table, how do you handle?

1 5252

why oracle is the best database for data warehousing?

HCL,

4 9367

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

2136

Un-Answered Questions { Data Warehouse }

what are factless facts? And in which scenario will you use such kinds of fact tables.

1812

Ist the schema that a data warehouse system can implements.

942

how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

1074

Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio

1754

How many input parameters can exist in an unconnected lookup?

1551

What is the data type of the surrogate key?

1006

What are the names of the layers in etl?

1002

Define meta stage?

1207

How to test report in reportnet?

1016

how you can enable bulk load mode in ti?

What is surrogate key? Explain with examples.

1164

Have you used Unstructured data?

1326

What is core dimension?

1067

How do you specify the number of iterations and specific condition within a single do loop?

1111

What are the different types of reports present in cognos?

988

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