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

Difference between sequential file and data set?

1198

What is a merge in datastage?

1268

How to perform incremental load in datastage?

1203

What is the flow of loading data into fact & dimensional tables?

1062

What are the functionalities of link partitioner?

1022

What is the purpose of pivot stage and types of containers in datastage

1037

How can we improve performance of data stage jobs?

1017

What are system variables and sequencers in datastage

1115

Difference between data warehousing and olap?

1089

What is the difference between operational data stage (ods) and data warehouse?

1240

What are the types of containers in datastage?

1191

Explain entity, attribute and relationship in datastage?

1101

Difference between in process and inter process?

1234

What are stage variables and constants?

1147

What are the components of datastage?

1123

Un-Answered Questions { Data Warehouse }

Differentiate between router and filter transformation?

1012

What is oltp?

977

What is maximum storage capability of SAS?

1423

How we can covert server job to a parallel job?

1146

Differentiate between a repository server and a powerhouse?

1118

What you mean by drill across and what is the difference between drill through, drill across?

1026

Explain fact constellation schema?

1036

what is data integration? : Sas-di

1118

Explain the types of lookup transformation?

1045

How can one identify whether mapping is correct or not without connecting session?

1448

Explain difference between zabo and webi?

1099

Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

1130

Can you explain the process of calendar?

1116

Your account is locked and your administrator has forgotten the password. What would you do?

1031

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1152

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