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

what is master-detail report

Patni, TCS,

3 15551

whats the diff between break and section

TCS,

4 10422

what is universe null

TCS,

2433

what is the filter?

1 5150

As im new to BO, tel me 1.How to do migration from BO6.5 to BOXIR2? 2.whats the difference b/w BO6.5 to BOXIR2. 3. whats the way both BO 6.5 n BOXIR2 file storge varies.

Cap Gemini,

5 11912

Is it possible to generate reports without having knowledge of the Universe structure?

4 7311

i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control list, i want WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country names. When i click on WESTERN_COUNTRIES, it should retrieve USA, UK records and when i click on ASIAN_COUNTRIES, it should retrieve INDIA, CHINA records. How is it possible?

Tech Mahindra,

4 10071

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

Infosys,

2112

In which type of report we can create school time table in cognos? [I want period numbers in rows like period 1, Period 2, period 3, period 4, period 5 and class numbers in columns like 8th class, 9th class, 10th class and subject names in cells] Genelally school time table is prepared in crosstab report, but subject names are not measures and a crosstab cell can not contain non-measures. This is my problem,,,,,

Tech Mahindra,

2 7783

How can you create prompts in framework manager?

Tech Mahindra,

4 24847

What are the differences between cognos reportnet 1.1 report studio and cognos 8 report studio?

3 7152

what is the difference between count and running-count functions?

1 16845

How much time it will take to develop a report in real time? It depends upon the complexity of the report, so tell me the approximate time period for a simple list, cascading, master-detail, drill-through,..…etc?

3 6756

How can we improve performance in report studio level?

1 6579

How can we improve performance in framework manager level?

Wipro,

3 13123

Un-Answered Questions { Data Warehouse }

Is the value of staging variable stored temporarily or permanently?

1012

What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.

2556

What is the conflict resolution window?

1071

What was the last computer book you purchased? Why?

2393

describe the interaction table in sas di? : Sas-di

1045

What are the uses of client software involved in teradata?

997

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3389

Explain what is the limit to the number of sources and targets you can have in a mapping?

1014

Explain what are the advantages data mining over traditional approaches?

1175

Write the unconnected lookup syntax and how to return more than one column.

1125

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1934

What does microstrategy intelligence server allow users to do?

999

What is rollup component?

1256

How we can create indexes after completing the loan process?

1225

Define cognos report net?

987

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