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?

1153

How scientific data processing is different from commercial data processing?

1094

What would be the next step after collecting the data?

1202

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

1186

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

1374

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

1183

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

1057

What do you mean by a transaction file?

1267

Difference between informatica vs ab initio?

1322

How transaction file different from that of a sort file?

1424

Mention what is abinitio?

1003

What is the model filter?

1022

Define datastores in cognos?

960

What is the metric store database?

976

Explain the difference between powerplay transformer and power play reports?

1030

Un-Answered Questions { Data Warehouse }

what specific features and functionality do you get with olap services?

973

Can anybody tell me what are the tuning problems?

2048

What kind of application/services uses Redshift database?

Describe the ways in which you can create macro variables? : sas-macro

1070

i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

2381

How does the bre work with the co>operating system?

1101

Mention what the difference between “look-up” file and “look is up” in abinitio?

1315

What is the main difference between inmon and kimball philosophies of data warehousing?

1120

Explain transaction control transformation in informatica

1275

What is the difference between absolute filtering and standard filtering?

1058

What is the difference between set functions and filter function in dimensional data?

2921

What is the fact table?

1078

What are the steps involved after the disk manager passes the request?

1127

Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2343

How substr function works in sas?

1228

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