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 5685

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

ASM, TCS,

2 17299

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

6 25954

What is staging area?

11 27340

What is data merging, data cleansing and sampling?

Satyam,

6 23212

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

2 10498

Why do we use DSS database for OLAP tools?

2 6928

What is active and passive transformation?

10 41292

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

3 19929

How is Data Models Used in Practice?

1 5472

What is the difference between view and materialised view?

4 13237

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

IBM, Wipro,

2 21521

What is the approximate size of data warehouse?

Accenture, i3 Solutions,

6 38586

What is hash partition?

1 8338

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

2 19306

Un-Answered Questions { Data Warehouse }

Which statement does not perform automatic conversions in comparisons?

1860

Please explain the different stages in creating a report in cognos report net?

1060

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

2685

What tools would you use for that?

1165

How to load a Dimension ? and how to load a fact table?

1471

What is set to be Cognos configuration?

1084

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1089

What is an expression transformation in informatica?

1095

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1150

How to use procedural logic inside infromatica?

1328

Can you define query studio?

1019

What are the different etl testing categories as per their function?

1154

How do you truncate a table?

1219

What are iconv and oconv?

1307

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2116

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