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 universes can be created in a project?

1054

Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

1032

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

1274

How to generate the report from excel sheet?

1185

Explain how we drill up week to month?

1093

Is there any other repository domains rather than universe, security, document?

1048

What is the dense rank?

1236

What are all difference between business objects 6.5 and xi r2?

1034

Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1116

What are the steps to be taken to schedule the report?

966

Explain when to use local filter and when to use global filter?

1361

What is a fantrap in business objects?

1176

Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

1038

What is report template in b.o?

1015

What is difference between custom hierarchy and report based hierarchy?

1024

Un-Answered Questions { Data Warehouse }

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2140

how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

2422

What is the role of sas grid administrator? : sas-grid-administration

1291

Explain the architecture of amazon redshift?

What is blocking transformation?

1152

What is the difference between sandbox and EME?

1271

What are snapshots? What are materialized views & where do we use them?

1043

Name different type of objects in microstrategy?

936

What are session timeout and application timeout? Where we have to do this process?

1046

Explain what are the advantages and disadvantages of reporting directly against the database?

1003

Explain what are the measure objects?

998

What is metadata in context of a datawarehouse?

1060

What is a partition?

1171

Can the administrator easily maintain and manage microstrategy intelligence server?

1013

what is intially documentation in sas?

5057

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