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

996

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

1044

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

905

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

1136

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

1033

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

1178

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

963

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

879

what is the use of proc sql? : Sas programming

1059

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

1002

What are fundamental stages of data warehousing?

991

What are aggregate tables and aggregate fact tables?

966

What is vldb(very large databases)?

948

What is the difference between view materialized view and view?

1024

Explain datawarehousing?

1002

Un-Answered Questions { Data Warehouse }

What is ab initio enterprise meta>environment (eme)?

1463

what techniques and/or procs do you use for tables? : Sas programming

1000

How do you setup Lo-cockpit?

3079

any difficulitis have you phase while creating bo reports and how did u solve it

3392

Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

1000

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2030

What is the advantage of informatica?

1017

How many input parameters can exist in an unconnected lookup?

1496

What is size of a transaction and an array means in a datastage?

1243

What do you mean by teradata sql assistant?

1000

What is the use of stored procedures in teradata?

943

What is staging area referring to?

1054

Your account is locked and your administrator has forgotten the password. What would you do?

947

Explain why fact table is in normal form?

920

Do you need to know if there are any missing values?

997

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