1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

What do the SAS log messages "numeric values have been converted to character" mean?

Quintiles,

875

What are the implications?

Quintiles,

1175

How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

Quintiles,

1154

What does the RUN statement do?

Quintiles,

843

Why is SAS considered self-documenting?

Quintiles,

1 2560

What areas of SAS are you most interested in?

Quintiles,

1055

What versions of SAS have you used (on which platforms)?

Quintiles,

1004

What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?

Quintiles,

1 1885

How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?

Quintiles,

1 1657

What is the different between functions and PROCs that calculate the same simple descriptive statistics?

Quintiles,

1217

What are _numeric_ and _character_ and what do they do?

Quintiles,

1 1627

How would you create multiple observations from a single observation?

Quintiles,

1 1455

For what purpose would you use the RETAIN statement?

Quintiles,

1032

What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

Quintiles,

1989

What is the order of application for output data set options, input data set options and SAS statements?

Quintiles,

1073

Un-Answered Questions { Data Warehouse }

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

535

What are the settings that you use to configure the joiner transformation?

606

Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

1762

Where the applications and where ware house management system is used?

527

How will you monitor the errors received while running i-server and report?

502




What are the job parameters?

694

give the options which are available after importing data using ti?

5

how to load dimension table and fact table. plz tell me the steps.

1677

Define ds designer?

758

How to generate the report from excel sheet?

576

How might you approve all mappings in the archive all the while?

594

What is the difference between Standard and Metrics folder?

567

Explain a mapping, session, worklet, workflow, mapplet?

588

Describe the ways in which you can create macro variables? : sas-macro

568

What are the important features of datastage?

606

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