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,

884

What are the implications?

Quintiles,

1179

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,

1159

What does the RUN statement do?

Quintiles,

851

Why is SAS considered self-documenting?

Quintiles,

1 2572

What areas of SAS are you most interested in?

Quintiles,

1062

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

Quintiles,

1011

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

Quintiles,

1 1899

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 1683

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

Quintiles,

1222

What are _numeric_ and _character_ and what do they do?

Quintiles,

1 1635

How would you create multiple observations from a single observation?

Quintiles,

1 1470

For what purpose would you use the RETAIN statement?

Quintiles,

1040

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

Quintiles,

2004

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

Quintiles,

1080

Un-Answered Questions { Data Warehouse }

How do you generate sequence number in datastage?

623

What are the issues you have faced in your project? How did you overcome those issues?

1910

Highlight the need for Performance Tuning.

584

Compare cold fusion with other programming languages?

556

what is the use of materialized view?

958




What are data validation strategies for data mart validation after loading process?

535

Explain what is a view as it relates to system modeling?

570

What are the steps involved in etl process?

513

What are the data types does SAS contain?

650

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

537

What is the command in bteq to check for session settings ?

634

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.

1206

When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?

1905

Explain what is a three tier data warehouse?

543

Define orabulk and bcp stages?

678

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