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

Your application mode has crashed. How would you get the instance back?

892

What do you mean by mstr?

1049

What do you mean by bulk export report?

892

What do you mean by xml cache?

934

Is it possible to get a floating window in microstartegy web? If yes, how?

1106

Explain fact structure?

940

What are the different types of mstr objects?

955

How will you monitor the errors received while running i-server and report?

907

Can you explain surrogate key?

987

Your application mode has crashed. How would you run your i-server?

909

What is an i-server? What are the different modes to run it?

939

How would you increase the logical size of a table in microstrategy?

922

According to you, what are the most important tables in a dw? Why?

934

Explain scan md?

1035

Explain fact constellation schema?

994

Un-Answered Questions { Data Warehouse }

What is union transformation?

922

What are the different kinds of panes included in cognos?

1011

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

1022

Define APT_CONFIG in Datastage?

1037

Can we create multiple integration service on single repository?

1150

What are the steps involved in the migration from older version to newer version of Informatica Server?

2064

Explain adhoc reports?

883

What are the difference between the sas data step and sas procs?

1121

What is difference between model & package?

999

How can you import tables from a database?

1020

What are the different types of reports present in cognos?

953

What is an expression transformation in informatica?

972

please please give me some banking calculations in framework manager.

2047

Under which circumstances, informatica server creates reject files?

1040

How do you import and export data into datastage?

1189

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