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?

866

Explain star schema?

930

How do you achieve schema object version control?

956

What do you mean by consolidations?

975

Explain the difference between holap and rolap?

945

Explain fact table?

993

Explain absolute filter?

920

what are the different authentication modes available in microstrategy?

1061

What is a dw? Why do we need it?

912

Explain adhoc reports?

883

How would you configure wh authentication?

899

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

913

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

940

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

896

Un-Answered Questions { Data Warehouse }

how can you put a "trace" in your program? : Sas programming

1018

What is surrogate key? Where we use it explain with example?

881

Which are the olap tools available that are supported by oracle?

901

What are stage variables and constants?

1108

why do u need the IOS upgradation in a FC switch

2239

Can you define report item?

996

What is fact extension?

1042

What is the purpose of upsert command?

1103

why is sas considered self-documenting? : Sas programming

1096

what are _numeric_ and _character_ and what do they do? : Sas programming

1118

What is the advantage of informatica?

1025

What is the difference between input and infile statement?

1126

Highlight the main features of datastage?

1108

How many types of views are there in a datastage director?

1248

how do u set partition points in the mapping?

2536

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