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 …
Or Read also: Unix interview questions and answers part – 1 The basename command deletes any prefix ending in ‘/’. This will display only file name. Or Read also: …
Returns the year from the given date. Input: date Output: year (int16) Examples. If mylink.mydate contains the date 2013-08-21, then two following functions are equivalent, and return the value …
