Status Name Status Code Explanation DSJS.RUNNING 0 Job is actually running DSJS.RUNOK 1 Job finished a normal run with no warnings DSJS.RUNWARN 2 Job finished a normal run with …
Defining your data When transforming or cleansing data, you must define the data that you are working with. You define the data by importing or defining table definitions. You …
Input file: Sno,name,salary,rank 1,Naveen,10000,2 2,Joe,20000,2 3,David,30000,1 4,Richard,30000,2 5,Obs,30000,1 1,Naveen,10000,2 1,Naveen,10000,2 3,David,30000,1 Output file: 1,Naveen,10000,2 1,Naveen,10000,2 3,David,30000,1 The final job design would be: First sequential file stage used to read …
TimeDate function returns system time and date as a formatted string. Input: – Output: system time and date (string) Examples. If the job was run at 4.21 pm on …
Returns the week number in the year from the given date Input: date Output: week (int16) Examples. If mylink.mydate contains date 2013-12-28, then the two following functions are equivalent, …
This is the basic concept we need to learn after code/develop DataStage jobs. In this post, I will explain how to export the jobs from one datastage server and …
“RDBMS code 6706: The string contains an untranslatable character.” Did you get this type of error in DataStage while loading data into Teradata or any other database. If yes, …
Buffering could be a technique used in the DataStage jobs to make sure a constant and uninterrupted flow of data to and from stages in such a way that …
