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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

which date function advances a date, time or datetime value by a given interval? : Sas programming

 584

name several ways to achieve efficiency in your program? : Sas programming

 562

how does sas handle missing values in sort order? : Sas programming

 517

what versions of sas have you used (on which platforms)? : Sas programming

 569

how could you generate test data with no input data? : Sas programming

 610

how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

 589

how would you determine the number of missing or nonmissing values in computations? : Sas programming

 646

how does sas handle missing values in functions? : Sas programming

 589

why is sas considered self-documenting? : Sas programming

 672

what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

 599

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

 639

how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

 827

do you prefer proc report or proc tabulate? Why? : Sas programming

 564

what is the effect of the options statement errors=1? : Sas programming

 575

how would you create multiple observations from a single observation? : Sas programming

 560

Un-Answered Questions { Data Warehouse }

What are the steps to be taken to schedule the report?

547

How is the partitioning with key different from round robin partition?

655

When and why we should use Redshift Spectrum?

5

What are datastage sequences?

659

How to pivot data using informatica when you have variable amount of pivot rows?

509




Compare etl & elt?

544

What is meant by a Least Cost Plan?

614

Define Routines and their types?

614

Differentiate primary key and partition key?

567

What are the Types of parallelism in detail?

691

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

1774

Explain input and put function?

633

Describe 5 ways to do a “table lookup” in SAS?

690

What is data type of the surrogate key?

602

Can we create Hierarchies in generic datasources?

1916

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