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 8552

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 5363

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

IBM,

2 5020

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

1 11574

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

HCL,

3 15999

Interval Prompt's Usage? Example for usage in Project

Cap Gemini,

2 16063

How can we find out cardinality between two tables?

IBM,

3 10925

what are determinants?

College School Exams Tests, IBM,

4 10817

how to connect the hyperlink in webi reports?

TCS,

7 27711

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

TCS,

2 12247

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

TCS,

5 9430

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

TCS,

1 4039

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

TCS,

3 7035

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

CTC, TCS,

2311

how to hide the prompts?

TCS,

7 11783

Un-Answered Questions { Data Warehouse }

what is the output when -1 is put in select_expr of FBE?

1415

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

966

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2134

What is hybrid slowly changing dimension?

1047

What Is The Difference Between Oltp And Olap?

1141

What is the use of the %include statement?

1179

How to get sql from obiee for reports?

895

How to elaborate powercenter integration service?

1148

what is pmrep command?

2446

Write the unconnected lookup syntax?

1093

i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

2503

You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?

943

What is Discrete and Continuous data in Data mining world?

2655

what are input dataset and output dataset options? : Sas programming

1117

How to convert a numeric variable to a character variable?

1219

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