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

Explain system call error?

1009

what are the criteria used by the microstrategy sql engine to build the join tree of a report’s sql?

951

You have got the requirement from a client. Explain the technical approach you will take now.

973

Explain about compound key?

1080

Explain clustering?

977

Your application mode has crashed. A.) How would you run your i-server? B.) How would you get the instance back?

900

Explain security role?

939

Explain attribute role?

1084

Compare dataset and fileset?

1039

What are objects?

1018

Explain 4gt switch. Does it have any drawback?

967

Explain confirmed dimensions. When are they used?

983

Is it possible to limit the number of reports run by a users at a time? How? What will happen if this limit is exceeded?

1029

What is the effect of dls on microstrategy?

1005

What do you mean by staging area?

972

Un-Answered Questions { Data Warehouse }

how would you create multiple observations from a single observation? : Sas programming

1005

What are the steps involved in designing a fact table?

891

Explain the pipeline partition with real time example?

1144

Name the various types of filters?

947

What is grain of fact?

978

define snapshot?

Differentiate between datastage and datastage tx?

1051

how do you want missing values handled? : Sas programming

958

what is sas database server? : Sas-di

1133

How rejected rows are managed in datastage?

1522

What are the functions of the replicate and dedup component?

1092

We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2525

Explain the main difference between inmon and kimball philosophies of data warehousing?

969

what is session partitioning?

2129

In banking domain how many Fact tables,Dimension table are present?

8801

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