Category: DATASTAGE TUTORIAL
If you are migrating an existing DataStage™ server on a UNIX® or Linux® computer, you must save copies of certain configuration files. The environment variable $DSHOME identifies the engine …
Input Records: 123,Naveen 124,Joe 125,Gary 124,Joe 126,Mahesh 127,Bob 126,Mahesh 124,Joe We need to capture the duplicates from above data using Remove Duplicate stage along with any other stage. Expected …
You can automate the comparing DataStage jobs across environments or same environments using a diffapicmdline.exe file. This is provided by IBM and resides in C:\IBM\InformationServer\Clients\Classic directory. We need to pass …
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 …
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 …