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

1150

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

1135

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

1011

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

1313

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

1192

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

1297

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

1044

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

980

what is the use of proc sql? : Sas programming

1193

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

1157

What are fundamental stages of data warehousing?

1088

What are aggregate tables and aggregate fact tables?

1099

What is vldb(very large databases)?

1079

What is the difference between view materialized view and view?

1121

Explain datawarehousing?

1120

Un-Answered Questions { Data Warehouse }

What is fact extension?

1211

What is rollup component?

1315

What would be the value of month at the end of data step execution and how many observations would be there?

1235

what is epilog tab?

if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

1663

How many types of transformations supported by sorted input?

1287

What is lookup table in etl testing?

1235

How to update or delete the rows in a target, which do not have key fields?

1227

List any five applications of data warehouse.

991

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

2229

What is the Rank index port in Rank transformation?

1105

What needs to be done while starting the database?

1164

When do you use sql override in a lookup transformation?

1144

Describe the evaluation of parameters order in ab initio?

1579

What is a dimensional model?

1035

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