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 the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

1085

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

1083

which date functions advances a date time or date/time value by a given interval? : Sas programming

955

What do the mod and int function do? : Sas programming

1228

what has been your most common programming mistake? : Sas programming

1107

what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

1238

what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

1007

what are some good sas programming practices for processing very large data sets? : Sas programming

931

what is the use of proc sql? : Sas programming

1133

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

1079

What are fundamental stages of data warehousing?

1046

What are aggregate tables and aggregate fact tables?

1040

What is vldb(very large databases)?

1013

What is the difference between view materialized view and view?

1074

Explain datawarehousing?

1044

Un-Answered Questions { Data Warehouse }

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

1017

Compare aggregates and data marts

2765

What is use Array size in datastage

1779

What do you mean by derived metrics?

996

Differences between connected and unconnected lookup?

1218

Explain the scenario which compels informatica server to reject files?

1168

What is the function of model design accelerator?

954

How many ways are there to do 'remove duplicate records in informatica'?

1014

tell me 5 session failure in real time how can you solve that in your project?

2303

What is the difference between teradata and basic rdbms?

1023

What is a clique?

1094

hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

2057

According to you, what are the most important tables in a dw? Why?

985

How we can decided drilling options for an attribute?

984

How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4717

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