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

What happens if the owner of an object does not exist in the destination project?

918

Can microstrategy desktop access operational data systems?

1070

What are attribute roles?

974

Does microstrategy web support clustering via cisco local router or any other third-party clustering software?

984

Can I access intelligent cubes without olap services?

1046

Can intelligence server integrate with my existing data structure?

1061

How do you ensure simultaneous releases across multiple operating systems?

970

Can reports be executed in off-peak periods?

997

Can microstrategy desktop access sap data?

948

How is the number of passes in a sql query significant in performance evaluation?

968

Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?

1012

Is microstrategy desktop available in other languages?

1010

what is the difference between microstrategy and cognos?

928

what specific features and functionality do you get with olap services?

966

What are consolidations?

908

Un-Answered Questions { Data Warehouse }

Where the data cube technology is used?

959

how to do user inputs and command line arguments in sas?

3047

Explain about alerts in bos, under what situation we need to use alerts?

1052

What is the sortmerge collector?

1130

What are three tier systems in etl?

1066

Explain the architecture of obiee and what each components do?

857

can anybody mail me the FAQS for hyperion essbase amd planning

5646

What is the difference between account and directory options ?

1182

If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.

2110

What is the information present in the cognos configuration file?

958

Different circumstance which drives informatica server to expel records?

983

What is the difference between ‘macro’ and ‘prompt?

1085

Explain informatica architecture - version 8 / 9

1089

What do you understand by a term domain?

1125

What is sandbox?

1206

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