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?

2175

Explain clustering algorithm?

2336

What is Time Series algorithm in data mining?

2 6513

Explain Association algorithm in Data mining?

2354

What is Sequence clustering algorithm?

2074

What are algorithms provided by Microsoft in SQL Server?

2113

How does data mining and data warehousing work together?

2 15255

What is XMLA ?

1 4477

What is Discover and Execute in XMLA?

2469

What is a universe?

TCS,

8 14607

Analysis in business objects?

4 9228

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

2 8500

How can you check the universe?

3 9623

What are universe parameters?

6 21436

Types of universes in business objects?

TCS,

20 40116

Un-Answered Questions { Data Warehouse }

What is de-partition in abinitio?

1421

How did you plan your Data ware house project?

2366

What is freehand sql?

1102

What are the themes in a data warehouse?

1100

Explain rw document?

1155

Explain etl?

1036

How do you reject records in a transformer?

1181

what is the output when -1 is put in select_expr of FBE?

1448

how to abort the job its matain duplicates?

2628

Define pmcmd command?

1109

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2407

How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1135

1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.

2250

Can you explain repository tables in datastage?

1460

What is the difference between dml expression and xfr expression?

1160

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