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

Why cognos scenario is used?

1080

What are the methods by which it non-durable model could be changed into the durable model?

967

What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

1181

What do you understand by the term 'model durability'?

1031

What do you understand by the term 'aggregate advisor?'

977

What do you understand by the term 'dynamic cube'?

1027

Write types of folders present in cognos?

1095

What are types of batch available in cognos?

986

What are the different types of reports present in cognos?

1000

What do you understand by the term 'aggregate cache'?

993

Write some methods to apply securities in framework manager model?

1128

Write various indexes used in cognos?

981

Define catalog in cognos and write its various types?

1195

What is the use of report studio?

1044

What do you understand by ‘ibm predictive maintenance and quality’?

1004

Un-Answered Questions { Data Warehouse }

Explain where do we use semi and non additive facts?

1033

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7421

Differences between connected and unconnected lookup?

1231

what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?

4012

Explain difference between e-r modeling and dimentional modeling?

1000

Can you highlight the main features of ibm infosphere information server?

1101

How are models actually derived?

2015

whats the difference between previous version of cognos and cognos 8 BI?

5548

Define different types of attributes in microstrategy desktop?

1252

what is the difference between cubes and package in cognos

4966

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1148

What is the advantages data mining over traditional approaches?

984

Explain how many types of dimensions are available in informatica?

1117

How do dates work in sas?

1153

What are all types of Batches?

1040

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