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

1128

explain about data integrator metadata reports? : Sas-di

1113

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

1038

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

1020

what is star schema? : Sas-di

1133

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

1005

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

1085

what is sas application server? : Sas-di

1085

what is sas olap server? : Sas-di

1261

what is sas metadata server? : Sas-di

1108

describe about metadata object? : Sas-di

1077

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

1032

what is data integration? : Sas-di

1123

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

1115

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

973

Un-Answered Questions { Data Warehouse }

What are all the types of indexes in Cognos?

1238

What is incremintal loading?

1116

What system options would you use to help debug a macro? : sas-macro

1101

Can you define folder?

969

Highlight the differences between Primary Key and Primary Index.

1096

How rejected rows are managed in datastage?

1526

Explain what is partitioning? What are the types of partitioning?

973

What formatting can be applied to the information that is sent out by microstrategy narrowcast server?

995

What are the uses of sas?

1277

Where $mpjret is used in ab-initio?

1150

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1503

What is difference between symmetric multiprocessing and massive parallel processing?

1149

Define ramp limit in ab initio?

1291

What are situations where snowflake schema is better than star schema when the opposite is true?

983

What do you know about sas and what we do? : sas-grid-administration

1150

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