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 5614

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

ASM, TCS,

2 17188

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

6 25764

What is staging area?

11 27012

What is data merging, data cleansing and sampling?

Satyam,

6 22988

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

2 10395

Why do we use DSS database for OLAP tools?

2 6858

What is active and passive transformation?

10 41036

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

3 19778

How is Data Models Used in Practice?

1 5403

What is the difference between view and materialised view?

4 13086

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

IBM, Wipro,

2 21409

What is the approximate size of data warehouse?

Accenture, i3 Solutions,

6 38381

What is hash partition?

1 8253

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

2 19218

Un-Answered Questions { Data Warehouse }

What is the function of parser component in teradata?

1092

What is the general format of function in sas? : sas-grid-administration

977

How can we remove the duplicates from flat file source?

1046

can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com

2154

How to delete data which is not in source table?

1348

What is the complex report you faced in real time?

2184

What is meant by query override?

1063

what are the filters in framework manager and report studio?

996

Explain what is the difference between view filter and report filter?

986

What are data-driven sessions?

1219

How can we use mapping variables in informatica?

1068

what does the run statement do? : Sas programming

1061

How you can fix the truncated data error in datastage?

1798

How can you define user defied event?

1035

What is the need of etl tools?

1123

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