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

1084

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

956

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

1228

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

1108

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

1239

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

932

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 }

Explain fact relation?

1014

Explain snowflake schema?

1034

4. How many dimensions did you use in your reports?

1953

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2182

State the limitations where we cannot use joiner in the mapping pipeline?

1067

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

1060

How do you set the session mode parameters in bteq?

1103

You have got the requirement from a client. Explain the technical approach you will take now.

973

explain checkin and checkout?

1142

What is a quality stage in datastage tool?

1076

What are “business rules” in ab initio business rules environment (bre)?

2023

What are the reasons to use a chameleon method in data warehousing?

1057

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2721

What are the benefits of using AWS Redshift?

What is usage analysis in datastage?

1307

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