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?

857

Can microstrategy desktop access operational data systems?

1006

What are attribute roles?

920

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

911

Can I access intelligent cubes without olap services?

959

Can intelligence server integrate with my existing data structure?

983

How do you ensure simultaneous releases across multiple operating systems?

908

Can reports be executed in off-peak periods?

937

Can microstrategy desktop access sap data?

887

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

901

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?

945

Is microstrategy desktop available in other languages?

961

what is the difference between microstrategy and cognos?

870

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

895

What are consolidations?

839

Un-Answered Questions { Data Warehouse }

Can you define drill down and drill up?

993

Is possible to create skid in dim,fact tables?

2590

1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?

2512

what is the difference steps for data modeling?

2050

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2096

Name few SAS functions?

1044

What is the advantage of using shortcuts?

1112

What is the length assigned to the target variable by the scan function?

1098

what are logical views used for?

953

what is information maps?

2156

What is the enterprise class platform architecture of cognos 8?

972

What are the methodologies of data warehousing?

923

If a Node is busy what are the steps you can take to avoid ?

2349

What is meant by a Parsing Engine?

1133

What is the model filter?

958

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