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

How to specify variables to be processed by the freq procedure?

1043

Give some examples where proc report’s defaults are different than proc print’s defaults?

1019

If a variable contains letters or special characters, can it be numeric data type?

1169

Explain how merging helps to combine data sets.

1005

What is the purpose of trailing @ and @@? How do you use them?

1004

Explain what is data step?

1154

What is the difference between class statement and by statement in proc means?

1218

What are the differences between proc means and proc summary?

1086

What’s the difference between var b1 – b3 and var b1 — b3?

1293

Mention what is the difference between nodupkey and nodup options?

973

What are the default statistics for means procedure?

1189

How does proc sql work?

1035

If a variable contains only numbers, can it be a character data type?

1044

What are the steps involved in creating dimensional modeling process?

967

What is the difference between agglomerative and divisive hierarchical clustering?

1130

Un-Answered Questions { Data Warehouse }

what are informats in sas? : Sas-administrator

1038

What is MPP in Redshift ?

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

1980

Can you define a query subject?

985

What are objects?

954

Can sorting and storing be done through single software or you need different for these approaches?

1067

Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

1866

What is the difference between hashfile and sequential file?

1204

List down the reasons for choosing sas over other data analytics tools.

1225

What is dimensional modeling?

1029

Do we need an ETL tool? When do we go for the tools in the market?

906

how to delete one row in target dataset

3083

in u r data u having duplicates how to fetch the latest data in our report?

5657

What are the ways to do a “table lookup” in sas?

989

What will be the skew for, input file->partition by key-> partition by round robin->output file

925

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