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

Example of how the fantraps and chasm traps works?

IBM,

1 14766

What are the types of errors you faced while creating a report from two different data providers

IBM,

3 7141

What are the types of errors you faced while creating a report from two different data providers

IBM,

3 10374

What is the difference between a table and the materialized view?

2 8442

what will we have to do if we want to generate an existing report in different language for different countries??

1 3492

What is the difference between bitmap and btree index?

CTS, TCS,

2 10115

Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com

2554

What is the difference between SAS Data step and SAS PROC SQL, and which is better?

TCS,

1 11602

Does anybody has lastest SAS certification dumps,if anybody has please mail me on saggydesai@gmail.com

2 5040

In the SAS Data step what is the difference between the subsetting done by Where and subsetting done by If?

Cognizant,

6 20068

my cient has reports in java and the dw mart is there already, whether you will suggest for Cognos reports ?

IBM,

1 5204

Main Differnce between Cognos7 and Cognos8

IBM,

1 6181

Increasing no of amps will increase performance. Is this true?

Infosys,

5 15071

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 11212

1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

2244

Un-Answered Questions { Data Warehouse }

What is real-time datawarehousing?

1030

Can you explain the advantage of using shortcuts?

1036

What is is a star schema?

1178

What do you understand by term role-playing dimension?

1052

Explain proc sort?

1124

Define data aggregation?

1105

What is the use of an aggregator cache file?

1203

how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.

874

What is zero-foot print?

1023

What is meant by Teradata Gateway?

1067

Cleared COG-112 with 100% score today. What next certification should i go for?

1840

Explain what sort of existing documents should business analysts refer to when starting on a new project?

1010

What is informatica powercenter repository?

1207

What is a partition and what are the different types of partition components in abinitio?

1278

Have you have ever worked in unix environment and why it is useful in datastage?

1134

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