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 repository in abinitio for stand alone system(local nt)?

1312

How do you convert 4-way mfs to 8-way mfs?

1 3424

What is m_dump?

1292

How can you force the optimizer to use a particular index?

1142

Describe the grant/revoke ddl facility and how it is implemented?

1216

When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?

1200

What is the purpose of having stored procedures in a database?

1234

What is the difference between a scan component and a rollup component?

1245

Explain the difference between the truncate and delete commands?

1224

Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?

1203

Can anyone give me an exaple of realtime start script in the graph?

1127

What is the difference between dml expression and xfr expression?

1170

How would you find out whether a sql query is using the indices you expect?

1129

What is $mpjret?

1209

How can I run the 2 gui merge files?

1246

Un-Answered Questions { Data Warehouse }

What is olap (on-line analytical processing?

1117

What are the informatica performance improvement tips

1159

Can you define bitmap index?

1148

Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

1221

Define dimensions?

1071

what are the errors,warnings in datastage

2784

what is sas metadata repository? : Sas-bi

1185

how we can load rejected record's at run time?(not through bad files)

2438

Mention the validation tools used in SAS?

1245

what is data access? : Sas-di

1191

Explain the special input delimiters used in sas programming.

1058

What is a sequence generator transformation?

1081

Explain the different dimensions.

1019

What are the different problems that ?Data mining? can solve?

2903

What could be a data source system?

1106

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