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 hide the table s in webi?can any one tell me plzzzzzzzz

Accenture, TCS,

9 32295

How could you generate test data with no input data?

CTS,

14 31113

How do you debug and test your SAS programs? What can you learn from the SAS log when debugging? How do you test for missing values? How would you create multiple observations from a single observation? What are some good SAS programming practices for processing very large data sets? Briefly describe 5 ways to do a "table lookup" in SAS. Why is SAS considered self-documenting? Are you sensitive to code walk-throughs, peer review, or QC review? What other SAS features do you use for error trapping and data validation? How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

2 17368

Can any one say me wat does"maintanence of universe" means wit?

Business Intelligence Analytics, NAL, TCS,

2 6331

How to link one location universe to other location universe

Cap Gemini, TCS,

3 10499

1)Difference between BO 5.1.2 and BO 6.5.1 and also BO XI (R2)?? 2)Difference between oracle 8i amd oracle 9i? 3)Difference between SQL and PL/SQL? 4)what is Broad cast Agent? 5)what is prompts? 6)master detail format means? 7)performance tuning of reports means? 8)ad-hoc reports means? 9)can't we generate reports without creating universe?

Oracle,

3 18157

Is that possible to Insert and Update a record in the Database through Microstrategy..?

11 25728

How could we generate the sequence of key values without using sequence generator transformation in the target ??

TCS, Tech Mahindra,

12 38310

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

Infosys,

2051

what is local filter

Cap Gemini,

2 8411

how to find the size of the report

1 4995

how many micro cubes can a report can have

3 8334

generally how do we get information for creating universes and reports

Satyam,

1 4754

what is report tracing in bo

Satyam, TCS,

5 11841

WHAT DIFFERRENCE DID YOU FIND AMONG VERSION 6 8 AND 9 OF SAS.

Genzyme,

4 7771

Un-Answered Questions { Data Warehouse }

Explain a relation schema and a relation?

1125

What are vaious etl tools in the market?

1018

Explain fact constellation schema?

1053

What is cluster AWS cloud?

what is sysdba and sysdbc ? which has high priority ?

3844

Explain what is analytical or analytic mean?

1029

Explain batch?

1002

explain html document?

1025

Different circumstance which drives informatica server to expel records?

998

What is drill down and slicing and dicing whats the difference between them?

1084

any one answer me how they can analyzing the project using data ware housing?

2492

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2508

Name and describe few sas character functions that are used for data cleaning in brief.

1138

What is an object prompt in microstrategy?

1018

How can create users and permissions in cognos?

974

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