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 slowly changing dimension? : Sas-di

1188

explain about data integrator metadata reports? : Sas-di

1171

what is transformation in sas data integration? : Sas-di

1091

what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

1061

what is star schema? : Sas-di

1190

for whom is sas data integration studio designed? : Sas-di

1066

explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di

1147

what is sas application server? : Sas-di

1144

what is sas olap server? : Sas-di

1302

what is sas metadata server? : Sas-di

1163

describe about metadata object? : Sas-di

1128

describe the interaction table in sas di? : Sas-di

1081

what is data integration? : Sas-di

1169

what is operational data and operational system? : Sas-di

1161

name some data transformation used in sas di? : Sas-di

1038

Un-Answered Questions { Data Warehouse }

Explain if a flat file cotains 1000 records how can I get first and last records only?

972

What are the components of the report studio?

1253

Explain the use of proc gplot? : sas-grid-administration

1047

What is meant by target load plan?

1032

for whom is sas data integration studio designed? : Sas-di

1066

What is the difference between proportion and average?

3407

What is meant by a Least Cost Plan?

1113

At which levels you can set the vldb properties? Which level has the highest pecedence?

992

What are the special input delimiters used in SAS?

1245

Does redshift support unstructured data?

Define the various join types of joiner transformation?

1045

How to read multiple files using a single datastage job if files have the same metadata?

1306

What is lookup table in etl testing?

1236

What is the difference between class statement and by statement in proc means?

1399

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2474

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