Returns number of days from source date to the given date. Input: source_date, given_date Output: days_since (int32) You can watch video tutorial of this function here:
Returns a date from the given julian day. Input: julianday (uint32) Output: date Examples. If linkname.julcol contains the value 2454616 then the function returns the date 2008-05-29. You can …
Returns a date by adding an integer to a baseline date. The integer can be negative to return date that is earlier than the base date. Input: number (int32), …
You can declare and use your own variables within a Transformer stage. Such variables are accessible only from the Transformer stage in which they are declared. Stage variables can …
Below video explains simple DataStage job using IF THEN ELSE condition in transformer stage. Assign a value that meets the specified conditions.If…Then…Else Operator Syntax variable = If condition Then …
Below video explains simple DataStage job using constraints in transformer stage. Video Transcripts: You can declare and use your own variables within a Transformer stage. Such variables are accessible …
What is a Surrogate Key, why we used it? How can we generate Surrogate Key in DataStage jobs? Explain the options available in the stage. Which are the Partition …
Problem: Oracle Connector Stage commits data even when a IBM DataStage job aborts and record count is zero. Symptom: Oracle Connector Stage commits data even when a IBM Data …
