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 the use of AFD? Where it can be stored?

1 8944

what is the source for metrics?

2 6078

Why do we need metrics and sets?

1 5398

What are the general issues in migration process?

Deloitte,

3 11760

What is the use of BO SDK?

5 19100

How can we improve performance?

2 7328

How to select multiple values from Type-in prompt? Example - I want to enter into type-in prompt in 'Product name--- Liza' display report data in 'product name is Leza' only OR I want to enter into type-in prompt in 'All', that time display report data in all are report data. How is possible this Scenario using in type-in prompt.

HSBC,

5 15130

Can you give an example of any complex report you designed using Actuate?

TCS,

2 9232

how to do pergformence tuning in datastage?

MCA, Symphony, TCS,

4 43948

1.what is context? How u create? With example.

Polaris, TCS,

2 14266

2.What is loop? How resolve the loop?explain it?

TCS, UHG,

11 64670

3.what is alias?

Business Intelligence Analytics, TCS,

5 11484

4.what is repository? types

TCS,

8 18576

5.what is LOV? where it is store?

TCS,

3 15029

6.what is conformed dimension? R u used?

TCS,

8 20173

Un-Answered Questions { Data Warehouse }

What is the Rank index port in Rank transformation?

1107

define sparse cube?

Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

1102

How etl testing is different from database testing?

1131

While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?

978

Explain which columns go to the fact table and which columns go the dimension table?

972

According to you, what are the most important tables in a dw? Why?

1038

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1126

what is sas olap server? : Sas-di

1310

What are the various kinds of containers available in datastage?

1113

How do you load first and last records into target table?

1223

What is the use of AWS redshift driver?

Explain the purpose of substr functions in sas programming.

1118

What is time series wizard? When and how do you use it?

1697

Explain what Proc glm does?

1308

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