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 we can call macros with in data step? : sas-macro

1125

What is the maximum length of the macro variable? : sas-macro

1094

How long can a macro variable be? A token? : sas-macro

1214

What are symget and symput? : sas-macro

1315

What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

1038

What do you code to create a macro? : sas-macro

1141

Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

1199

How do you add a number to a macro variable? : sas-macro

1010

Can you execute a macro within a macro? Describe. : sas-macro

1111

For what purposes have you used sas macros? : sas-macro

1001

How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

1047

what is the purpose of _error_? : Sas programming

1136

what are input dataset and output dataset options? : Sas programming

1105

if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

1064

how can you put a "trace" in your program? : Sas programming

1065

Un-Answered Questions { Data Warehouse }

What are public objects?

1054

What is difference between model & package?

1030

What are the vldb properties? Which level of vldb configurations have the highest precedence?

943

What you mean by drill across?

1021

Explain what are the advantages and disadvantages of reporting directly against the database?

1003

CHANGE CAPTURE

1301

what are input dataset and output dataset options? : Sas programming

1105

How to identify ppi columns?

1180

What is union transformation in informatica?

1146

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1641

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

1051

Clarify the aggregator change?

1029

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

2206

Explain and compare pros and cons of snow flake schemas?

1035

Tell e how how dealt with..

2253

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