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 data is processed and what are the fundamentals of this approach?

1200

How scientific data processing is different from commercial data processing?

1138

What would be the next step after collecting the data?

1247

Give one reason when you need to consider multiple data processing?

1226

We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?

1409

Have you ever encountered an error called “depth not equal”?

1227

Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?

1096

What do you mean by a transaction file?

1305

Difference between informatica vs ab initio?

1376

How transaction file different from that of a sort file?

1471

Mention what is abinitio?

1048

What is the model filter?

1079

Define datastores in cognos?

1002

What is the metric store database?

1014

Explain the difference between powerplay transformer and power play reports?

1081

Un-Answered Questions { Data Warehouse }

Explain about the data integration suite features?

1004

Explain what is the architecture of abinitio?

1264

Explain security filter?

1125

Give some difference between oltp and olap.

1070

what are different storage options supported by oracle ?

2140

Explain PDE.

1132

How were the reports scheduled and how to resolve unexecuted documents?

2729

What is depict expression change?

1204

Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

2279

How can sas program be validated?

1077

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

1058

How to limit the max no of rows retrieved in the report?

1039

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

1026

What are steps we have to follow in designing the userfriendly universe?

1021

Do you view contain data?

1012

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