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?

933

Explain four-tier connection?

867

Explain star schema?

930

How do you achieve schema object version control?

957

What do you mean by consolidations?

976

Explain the difference between holap and rolap?

946

Explain fact table?

993

Explain absolute filter?

921

what are the different authentication modes available in microstrategy?

1062

What is a dw? Why do we need it?

913

Explain adhoc reports?

883

How would you configure wh authentication?

900

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

914

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

941

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

897

Un-Answered Questions { Data Warehouse }

what is business intelligence? : Sas-bi

1022

what is chore commit property?

What is level metrics in microstrategy?

952

explain one complex mapping with logic? sales project?

6621

Can we access multiple operational databases from within a single microstrategy project?

1004

What is slibref?

1221

What are the data types present in bo? What happens if we implement view in the designer and report?

984

What is the role of unrestrictive users? : sas-grid-administration

973

What are pdv and it functions?

1067

What is edw?

1133

What are the stages that are required in data warehousing?

911

What actually a project contains?

1056

have u done any performance tuning? how u ll do?

2259

Why do we use link partitioner and link collector in datastage?

1092

Briefly define a session task?

1075

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