DS Macros are built from Data Stage functions and do not require any arguments. A number of macros are provided in the JOBCONTROL.H file to facilitate getting information …
This is one of the most asked DataStage scenario based interview questions. I will solve this problem by taking some sample data. Input file: Sno,name,salary,rank 1,Naveen,10000,2 2,Joe,20000,2 3,David,30000,1 4,Richard,30000,2 …
Each PL/SQL program consists of SQL and PL/SQL statements which from a PL/SQL block. PL/SQL Block consists of three sections: The Declaration section (optional). The Execution section (mandatory). The …
Block Structures: PL SQL consists of blocks of code, which can be nested within each other. Each block forms a unit of a task or logical module. PL/SQL Blocks …
SecondsFromTime function returns seconds portion of a time. Input: time Output: seconds (dfloat) Examples. If mylink.mytime contains the time 22:30:22, then the two following functions are equivalent, and return …
NextWeekdayFromDate function returns the date of the specified day of week soonest after the source date. The day of the week is specified as the full name, for example, …
HoursFromTime Function returns hour portion of a time. Input: time Output: hours (int8) Examples. If mylink1.time contains the time 23:30:00, then the following two functions are equivalent, and return …
This question can be answered easily in SQL in the following ways. Finding the nth highest salary in Oracle using rownum: Find nth highest salary in Oracle using RANK(): …
