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

How many types of facts and what are they?

1031

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

1071

Why we use repository connectivity?

992

The same tier?

1068

What is recovering sessions?

954

How to define a cube??

943

What is prompt types of prompts?use of prompts syntax of prompt?

1361

How to drill through from a powerplay cube to reportnet?

949

What is load manager?

1071

Start a batches with in a batch?

987

How to create different types of templates?

998

What is the difference between connected and unconnected stored procedures?

1098

What is a relationship?

1001

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

986

Where the applications and where

941

Un-Answered Questions { Data Warehouse }

What is the very basic difference between data warehouse and operational databases?

979

How to create a cube in Transformer? What is the process? Please mention process thank u

1778

How can you force the optimizer to use a particular index?

1082

What does cheating measurement mean?

1081

name the scheduler for scheduling job and explain the scheduler? : Sas-di

1057

Which date function advances a date, time or datetime value by a given interval?

1165

How to create context?

1019

What is the difference between static cache and dynamic cache?

1008

why is sas data integration studio important? : Sas-di

1054

What is the purpose of upsert command?

1192

Why does microstrategy object manager search for object dependencies?

979

What is package in BO

3220

Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

1930

What interface is used to connect to windows based applications?

1126

Did u used latest transformations of 8.6.0? for what?

1900

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