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

wat is report linking in BO..I know that 2 reports can be linked in BO with the help of writing a HTML code .But how. wat s the code.can u give me the example of code taking e fashion as the simple univers data provider.

Accenture,

2 8661

I have saved one file in GMT as a standard time and the server must convert it into local time. How to do it?

IBM,

1 5437

filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?

IBM,

2 5117

What is the use of Tree Prompt? Where it is used?Pls give me a real time example?

1 11647

What is the use of Generated Prompt? Where is it used in realtime project?

HCL,

3 16102

Interval Prompt's Usage? Example for usage in Project

Cap Gemini,

2 16156

How can we find out cardinality between two tables?

IBM,

3 11025

what are determinants?

College School Exams Tests, IBM,

4 10941

how to connect the hyperlink in webi reports?

TCS,

7 27887

what is the use of merge option in webi reports? explain with example?

TCS,

2 12349

how to connect one to one report? Explain with example?

TCS,

5 9589

any of the person working on encyclopedia? give the explanation briefly?

TCS,

1 4113

without creating the business view is there possible to create & generate the Crystal reports?

TCS,

3 7155

is it possible to export the webi reports to crystal reports?with out using businessview?

CTC, TCS,

2350

how to hide the prompts?

TCS,

7 11989

Un-Answered Questions { Data Warehouse }

What are the differences between proc means and proc summary?

1198

Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?

1150

Explain how to execute the plsql procedure from the report by clicking with mouse?

1103

Explain what are the possible data marts in retail sales?

1059

define drill through?

What olap capabilities do I have within a microstrategy report services document?

978

When do you use sql override in a lookup transformation?

1145

Explain the data types present in bo and what happens if we implement view in the designer and report?

1076

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?

2091

Can you define snapshot?

991

Explain difference between snow flake and star schema.

1121

can u give example for factless fact table

6788

Can I access intelligent cubes without olap services?

1112

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9904

Explain teradata architecture in detail with a diagram.

1173

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