Data Warehouse Interview Questions
Questions Answers Views Company eMail

How we can call macros with in data step? : sas-macro

618

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

627

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

721

What are symget and symput? : sas-macro

735

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

585

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

585

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

702

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

545

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

678

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

540

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

587

what is the purpose of _error_? : Sas programming

614

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

567

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

549

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

579


Un-Answered Questions { Data Warehouse }

Can you define drill across?

563


How to allow a dynamic selection of a column for a measure in a chart,without using variable?

515


how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

1977


How to generate a report by getting values from two reports. The generated report should contain the 5 values of first report and last 5 values of second report?

548


How to identify ppi columns?

660






what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1789


What are the different types of variables in obiee? Explain

517


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

616


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

619


what is the difference between unique key and primary key? : Sas-di

603


What type of indexing mechanism do we need to use for a typical data warehouse?

622


Give one reason when you need to consider multiple data processing?

631


What are the various methods of getting incremental records or delta records from the source systems?

535


What is VLDB?

610


What is meant by query override?

640