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 sas data set?

1106

How will you generate test data with no input data?

1173

What is the difference between input and infile statement?

1175

What is the difference between reading data from an external file and reading data from an existing data set?

1175

Describe the ways in which you can create a macro variable?

1084

Mention the category in which sas informats are placed?

1020

How substr function works in sas?

1222

What is the difference between informat and format statement?

1 1659

How do dates work in sas?

1138

What is the difference between the proc sql and data step?

1174

What is the good sas programming practices for processing large data sets?

1114

What is the difference between where and if statement?

1113

What are the different types of sas functions?

1282

Mention common programming errors committed in sas ?

1125

What is by-group processing?

997

Un-Answered Questions { Data Warehouse }

how do u set partition points in the mapping?

2239

What are the data types present in bo? What happens if we implement view in the designer n report?

934

What information is shared by the application across microstrategy web nodes?

1046

How to differentiate between the active and passive transformations?

1165

what is index?how it can work in informatica

2040

Can microstrategy desktop access operational data systems?

1070

What is a cursor? Within a cursor, how would you update fields on the row just fetched?

1179

What is program data vector (pdv) and what are its functions?

1246

What is cfapplication tag?

971

How we can monitor the performance of Redshift data warehouse cluster.

What's the layout of parameter file (what does a parameter file contain?)?

2385

What is the difference between one to one merge and match merge? Give an example.

1067

Steps to create a data model?

1132

when will use SQL override in a lookup transformation?

2291

What are the enhancements made in datastage 7.5 compare with 7.0?

1148

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