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 15523

whats the diff between break and section

TCS,

4 10392

what is universe null

TCS,

2426

what is the filter?

1 5137

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 11866

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

4 7269

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 10034

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,

2101

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 7751

How can you create prompts in framework manager?

Tech Mahindra,

4 24823

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

3 7130

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

1 16825

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 6722

How can we improve performance in report studio level?

1 6561

How can we improve performance in framework manager level?

Wipro,

3 13083

Un-Answered Questions { Data Warehouse }

What is TPD?

1374

Your colleague installed microstrategy on solaris or unix without root access. Will he be able to start/ restart this server?

970

Describe link sort?

1015

What if the source is a flat-file?

1112

How do users receive only information that they want?

981

what is the difference between cardinality and Nullability?

3454

Explain the aggregator transformation?

1167

How is cognos model organization works?

1093

What does cheating measurement mean?

1063

Difference between PowerPlay transformer and power play reports?

2517

What is a table alias in obiee? And where and how will you create it.

902

What are the benefits of data processing according to you?

1216

Store (and count) non-fact records?

935

Difference between star and snowflake schemas?

1155

What is the Rank index port in Rank transformation?

1061

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