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 create users and permissions in cognos?

IBM,

4 21291

How to test reports in cagonos ?

CST, CTS,

10 30104

How to create a dynamic column name in Cognos?

Aditya Birla, Polaris,

6 39047

what is model and how to create model and how to test model?

IBM,

8 17545

In Microstrategy, how can you direct the sql generated to use a specifc table?

5 13160

In Microstrategy, what are Logical Views used for?

InfoCepts, Marlabs, Tech Mahindra,

6 25318

can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

IBM,

1 9343

what is the difference between start schma and Fsldm?

Intel,

5 50296

In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?

IBM, Wipro,

2 13074

What are two examples of an OLTP environment?

4 15086

What is a common data source for the central enterprise data warehouse?

Wipro,

1 11501

Does SDLC changes when you use Teradata instead of Oracle?

2 11667

What are the new features of informatica 7.1?

2 7481

What are teh different tasks that can be created in workflow manager?

NIIT,

1 10124

What is the functionality of update strategy?

2 9369

Un-Answered Questions { Data Warehouse }

Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

4372

What are orabulk and bcp stages?

1165

What is a bo repository?

1110

What is a cursor? Within a cursor, how would you update fields on the row just fetched?

1237

What is data stream and data adapter is it same are different? Explain?

1029

Differentiate between router and filter transformation?

1066

What is the difference between writing a joiner query in ANSI style and THETA style?

2437

How is character variable converted into numeric variable and vice versa?

1222

Explain fact constellation schema?

1089

Name types of category in which SAS Informats are placed?

1199

Explain teradata utilities?

1099

What are the ways to import data into catalog?

1139

How can we delete duplicate rows from flat files?

1312

Explain attribute role?

1155

Your i-sever crashed. What will you do?

1110

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