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 a table alias in obiee 11g? Where and how will you create it?

1060

How will change port of obiee answers?

907

How will you create interactive dashboards ?

953

How will you enable or disable caching in the system level and table level?

935

How will effect the changes for a report , if for certain users only the column heading in the report should be changed?

850

How will you do sort in reports in obiee.

891

What are the different types of variables in obiee 11g? Explain

1035

can you change the location of the obiee repository?

899

How online/offline mode impact development and delpoyment?

891

From where u get the logical query of your request?

842

What are the major challenges you faced while creating the rpd?

920

What is data modeling and data mining?

1026

What are the ETL Testing Operations?

1102

Explain the use lookup tables and Aggregate tables?

1027

What is data cleaning?

1004

Un-Answered Questions { Data Warehouse }

What is the need for an etl tool?

1105

What are the different types of olap? Give an example?

1099

How do you use reject loader.

2653

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2199

Can we use target hash file as a lookup ?

3381

Explain what is the difference between datawarehouse and bi?

1021

What are the benefits of datastage?

1307

How to increase performance without changing anything in mapping.( In prod)

1314

: and & modifiers.

1454

What are the different types of variables in obiee 11g? Explain

1035

What is dynamic aggregation in microstrategy?

1027

Explain fact degradation?

1050

What happens when a session fails and you click on recover?

1178

How to performance tune reports?

1269

list and discuss two approaches for updation of target table in Informatica and how they are different.

2160

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