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

suppose the network connection between a webserver and clustered i-server gets lost. What will happen? Will the report still run?

977

Explain four-tier connection?

934

Explain star schema?

980

How do you achieve schema object version control?

999

What do you mean by consolidations?

1041

Explain the difference between holap and rolap?

980

Explain fact table?

1053

Explain absolute filter?

972

what are the different authentication modes available in microstrategy?

1107

What is a dw? Why do we need it?

977

Explain adhoc reports?

940

How would you configure wh authentication?

952

Imagine this, you are required to reset the password for all users at a time. How would you do that?

951

What are prompted filters? Have you ever used them? Where?

986

Can a record be inserted and updated in database using microstartegy?

931

Un-Answered Questions { Data Warehouse }

What is the difference between a primary and secondary actor in use case modeling?

1066

Which is the t/r that builts only single cache memory?

1190

How do you debug and test your SAS programs?

1559

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2479

State the difference between an operational datastage and a data warehouse?

1131

How can I schedule reports in cognos?

1008

options available in sequence job to run,validate?

1317

What is the difference between SAS functions and procedures?

1152

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1899

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

2005

-----------------What is Determination Model?

2138

Why should we use data ware housing and how can you extract data for analysis with example?

997

Why might the optimizer use a table scan when an index is available?

2311

What is the different type of jobs in datastage?

974

What is a ds designer?

1070

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