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(): …
What is the difference between Join/Lookup/Merge stages? How these will react if duplicates records come in input links? In join stage, if one input have col1,col2,col3 and other have …
Did you implement any SCD type in your jobs? If yes, Please explain it with job design. How can we implement SCD Type-2 in DataStage, Explain it in different …
There are two important divisions in UNIX operating system architecture. Kernel Shell In simple words you can say – Kernal – interacts with the machine’s hardware Shell – interacts …
Alias command in Unix is used to create alias for a command, lets say if you are using ‘ls -ltr’ frequently in your work and you want to replace …
