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

Can decision tree be implemented using SQL?

2065

Explain clustering algorithm?

2210

What is Time Series algorithm in data mining?

2 6296

Explain Association algorithm in Data mining?

2263

What is Sequence clustering algorithm?

1967

What are algorithms provided by Microsoft in SQL Server?

1984

How does data mining and data warehousing work together?

2 15018

What is XMLA ?

1 4312

What is Discover and Execute in XMLA?

2345

What is a universe?

TCS,

8 14055

Analysis in business objects?

4 8904

Who launches the supervisor product in Business Objects for first time?

2 8289

How can you check the universe?

3 9349

What are universe parameters?

6 20979

Types of universes in business objects?

TCS,

20 38833

Un-Answered Questions { Data Warehouse }

What are the special input delimiters used in SAS?

1104

Is Redshift a row based storage or columnar based?

Explain what would you consider as your biggest achievement and why?

925

what is proc Index? and what is proc document?

2633

What DB View and Bus View?

1934

What is smart metric?

917

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?

2183

what is the size of u r source(like file or table)?

2202

how would you create multiple observations from a single observation? : Sas programming

954

Compare sas with other data analytics tools.

983

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1842

Explain translate function?

1133

Explain how spool space is used.

1020

Why AWS redshift is named after Redshift?

Why do we need informatica?

928

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