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 a linked cube?

1053

What is a full backup?

1022

Do you view contain data?

1015

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

996

What is hybrid slowly changing dimension?

1094

Explain about core dimension,

1041

What is data warehouse architecture?

1107

What is degenerate dimension table?

1055

What is dimensional modelling?

1041

What are data validation strategies for data mart validation after loading process?

1068

What is surrogate key? Where we use it? Explain with examples.

1086

What is type 2 version dimension?

1029

What is the advantages data mining over traditional approaches?

1028

What is surrogate key? Where we use it?

1047

For faster process, what we will do with the universe?

1040

Un-Answered Questions { Data Warehouse }

Explain what are slowly changing dimensions?

1083

is there any difference between operational database and data base?if yes what r they?

2127

What is teradata?

1253

How many types of stage?

1236

What is transformation metric in microstrategy?

1077

What is a dimensional model?

1037

what are the cubes developed in a sap bw project and what is the requirement for developing it?

2146

What is metadata in context of a datawarehouse?

1141

Explain er diagram?

1044

why is a stop statement needed for the point=option on a set statement? : Sas programming

1141

suppose the network connection between a webserver and clustered i-server gets lost. What will happen? Will the report still run?

1029

what other sas products have you used and consider yourself proficient in using? : Sas programming

1175

How to create repository in abinitio for stand alone system(local nt)?

1312

What is scd1 , scd2 , scd3?

1148

How to implement complex jobs in data stage?

1169

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