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

Explain what is ods (operation data source)?

1003

Explain difference between data ware house & data mart?

996

Explain what is the difference between view filter and report filter?

991

What is data type of the surrogate key?

1014

Where the applications and where ware house management system is used?

1024

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

937

What is the difference between power center & power mart?

994

Explain what are conformed dimensions?

1097

Explain what is a staging area? Do we need it? What is the purpose of a staging area?

971

How to calculate fact table granularity?

1031

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

1072

what type of raid setup would you put your tx logs?

963

What is a general purpose scheduling tool?

1125

What is the metadata extension?

1009

What a static and local variable?

1089

Un-Answered Questions { Data Warehouse }

define cognos reporting tool?

What do you mean by tpt in teradata?

1030

What are the primary keys and foreign keys?

1153

What is usage analysis in datastage?

1321

What is a lookup table in etl?

1204

List the logical and conditional operators that are used with teradata along with their meanings?

1010

lookup transformation with screenshots

4014

What is option by which we can run all the sessions in a batch simultaneously?

1156

How do you manage the Parameter files while migrating your data from one environment to another environment?

1039

What is level metrics in microstrategy?

1051

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3597

What is publickey and private key?what is the use of this two keys?

2917

what is snowflake schema? : Sas-di

1227

What is ds designer?

1115

What are the features of ab initio?

1122

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