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 to startup obiee in linux?

934

What is clusterservices in obiee ? Why its used?

996

How will you create report from two subject areas

884

how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.

914

What is write-back in obiee ?

889

Explain the architecture of obiee and what each components do?

910

What are the different layers of obiee repository?

1 1316

How analytics process your request when you create your requests?

1000

Can you run multiple rpd’s in a single obiee instance?

843

What are the different log files in obiee?

1011

How will you go about adding additional column to the repository in the presentation layer?

973

What you will do when your report is not fetching right data?

969

What is star schema and snowflake schema?

1059

What are the different types of variables in obiee? Explain

946

what is guided navigation?

945

Un-Answered Questions { Data Warehouse }

How would you configure wh authentication? Explain.

1074

What are the join problems comes appart from loop,chasm & fan Traps

2192

What are the scenarios in which full table scans occurs?

1056

Can you define materialized view?

1108

Explain the term 'primary key' related to relational database management system?

1091

What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)

2183

------------ Diff b/w MemberCaption and MemberDescription?

2366

How does the internal authentication work in sas? : sas-grid-administration

1176

What is the SAS data set?

1180

----------------Diff b/w Dimensional modeling and Relational modeling?

15103

how to export or import the jobs in .ISX file

1258

What are the various indexes in teradata?

1107

What are level metrics? Why are they needed?

1092

What is crass reference table?

1100

What are products of cognos?

1028

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