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?

7495

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

2244

what are the reporting tools and difference between them?

2090

how do u automate Extraction process?

1 4809

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

3 8141

how do u identify the changed records in operational data?

QualTech,

2527

what is SMP AND MPP?

8 64476

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

2081

what are the facilities provided by OLAP to analytical users?

1 4723

what is HISTOGRAM? how to generate statistics?

1 5014

how do u set the size of block buffer?

1 4411

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

1 4913

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

1 5246

why oracle is the best database for data warehousing?

HCL,

4 9351

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

2129

Un-Answered Questions { Data Warehouse }

What is the fact table?

1071

If you want to use the same piece of code in different jobs, how will you achieve it?

1156

What is metadata in microstrategy?

1113

What DB View and Bus View?

1974

How to run a graph infinitely?

1121

What is oci?

1301

what do u do when DB time takes more?in sap bi

2205

Which function is used to count the number of intervals between two sas dates?

1129

Can we take backup when the database is opened?

1044

What are the uses of client software involved in teradata?

984

Have you used rollup component? Describe how.

1071

How can we Maintain the Cube Security by Category level and Dimension level ?

2359

What is size of a transaction and an array means in a datastage?

1313

Tell me about Dnamic and Static Dashboards?

2345

Explain the use of aggregator cache file?

1254

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