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 14851

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

IBM,

3 7245

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

IBM,

3 10514

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

2 8540

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

1 3551

What is the difference between bitmap and btree index?

CTS, TCS,

2 10228

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

2600

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

TCS,

1 11696

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

2 5153

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

Cognizant,

6 20268

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

IBM,

1 5309

Main Differnce between Cognos7 and Cognos8

IBM,

1 6242

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

Infosys,

5 15279

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 11412

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?

2295

Un-Answered Questions { Data Warehouse }

What do you understand by ‘ibm predictive maintenance and quality’?

1058

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1797

What is the use of virtual processor connectivity in teradata?

1096

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

1158

What is database exceptions in teradata?

1004

Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

2042

Explain what is analytical or analytic mean?

1059

what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

2065

How do you call a store procedure within a transformation?

1055

what are the errors faced while bursting the reports and how to solve those errors?

2072

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

1161

What do you understand by SOA of Informatica?

1049

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1831

What is real time and near real time data warehousing?

1164

What is an unconnected transformation?

1134

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