which date function advances a date, time or datetime value by a given interval? : Sas programming
584how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
589how would you determine the number of missing or nonmissing values in computations? : Sas programming
646in the flow of data step processing, what is the first action in a typical data step? : Sas programming
639how 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
What are the steps to be taken to schedule the report?
How is the partitioning with key different from round robin partition?
When and why we should use Redshift Spectrum?
What are datastage sequences?
How to pivot data using informatica when you have variable amount of pivot rows?
Compare etl & elt?
What is meant by a Least Cost Plan?
Define Routines and their types?
Differentiate primary key and partition key?
What are the Types of parallelism in detail?
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?
Explain input and put function?
Describe 5 ways to do a “table lookup” in SAS?
What is data type of the surrogate key?
Can we create Hierarchies in generic datasources?