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

explain the difference between proc means and proc summary?

1126

Mention the difference between ceil and floor functions in sas?

1153

How to include or exclude specific variables in a data set?

1120

What is substr function?

1188

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

1078

How can sas program be validated?

1034

Mention how to limit decimal places for the variable using proc means?

1115

What is a put statement?

1200

How to read an input file in sas?

1142

How sas treats the dsd delimiters?

1216

How can you limit the variables written to output dataset in data step?

1317

how to remove duplicates using proc sql?

1148

How to display duplicate observations in data?

1 1669

What are common programming errors committed in sas

1146

What are the difference between ceil and floor functions in sas?

1350

Un-Answered Questions { Data Warehouse }

how do u extract data from different data sources explain with an example?

2244

What is the different type of jobs in datastage?

974

How to generate sequence numbers without using the sequence generator transformation?

1206

Give the benefits of data integration suite?

921

differentiate between power play transformer and power play reports?

What are the different kinds of views available in a datastage director?

1030

Explain what are the tasks that loadmanger process will do?

927

Explain the pipeline partition with real time example?

1143

Can you explain the performance and scalability of co> operating system?

1126

What are the functions of the replicate and dedup component?

1092

What is the size of the cube?

973

how many rows sorted in sort stage by default in server jobs

3997

What is data analysis?

957

explain the main difference between the nodup and nodupkey options? : Sas-administrator

1162

Pdl with an example?

1106

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