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

What is query panel?

1 5692

What is a look up function? What is default transformation for the look up function?

ASM, TCS,

2 17311

What is difference between a connected look up and unconnected look up?

6 25992

What is staging area?

11 27373

What is data merging, data cleansing and sampling?

Satyam,

6 23240

What is up date strategy and what are the options for update strategy?

2 10508

Why do we use DSS database for OLAP tools?

2 6939

What is active and passive transformation?

10 41326

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 19951

How is Data Models Used in Practice?

1 5478

What is the difference between view and materialised view?

4 13257

What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

IBM, Wipro,

2 21532

What is the approximate size of data warehouse?

Accenture, i3 Solutions,

6 38615

What is hash partition?

1 8342

What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?

2 19322

Un-Answered Questions { Data Warehouse }

Mention sas system options to debug sas macros.

1249

Under what condition selecting sorted input in aggregator may fail the session?

1177

What is a mapping, session, worklet, workflow, mapplet?

1061

How can we check the version of Teradata that we are using currently?

1123

What are the conditions needed to improve the performance of informatica aggregator transformation?

1149

What is Bitmap Index?

1112

Can we create multiple integration service on single repository?

1245

What is full load & incremental or refresh load?

1255

Explain the characteristics of cognos?

1093

Explain security role?

1000

Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

1028

complex mapping ur project u r invlve can u explain and give real time example give me ?

2355

define over feeding?

Mention some file extensions which are used in abinitio?

1187

What are the limitations of amazon redshift?

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