I have explored all the available functions in the transformer stage, but could not find the exact function to get the last day of the current month. Can you please show me which function is available for this logic.
Routines are stored in the routines branch of the datastage repository, where you can create, view or edit. The following are different types of routines: 1) transform functions 2) before-after job subroutines 3) job control routines
What is the purpose of using user defined environment variables and parameter sets. I m little bit confused. Could any one explain me in detail.?
I came across this question many times in interview, in specific what can I answer..... Please help..
Input file a contains12345678910input file b contains6789101112131415output file x contains12345output file y contains678910output file z contains1112131415how can we do in this in a single ds job in px ?....Could you please give me the logic to implement ???
How do you you delete header and footer on the source sequential file and how do you create header and footer on target sequential file using datastage?
A sequences is calling activity 1, activity 2 and activity 3.While running, activity 1 and 2 got finished but 3 got aborted. How can I design a sequence such that the sequence has to run from activity 2 when I restart the sequences?
How to get top five rows in datastage? I tried to use @inrownum,@outrownum system variables in transformer..But they are not giving unique sequential numbers for every row...Please help! thanks in advance!!
I have a source file1 consist of two datatypes file1: no(integer) 1 2 3 & dept(char) cs it ie and I want to seperate these two datatypes and load it into target files file2 & file3. how can I do this in datastage and by using which stage?