DSXchange

under job properties you will find default tab
change the Date format with the one you are using

with the help of stage variables in transformer you can remove the duplicate

HI you can create one table A in which you can put these dates and then your job design will become job to extract from the table A for date and putting that into a file -----> read that file through a routine or unix command -----> pass these parameters taken from the file into the the main job ---...

just want to know if i will create a multiple instances of the job will it going to improve the performance

you can create the routine and read the sequential file

thanks for your inputs
jsut wanted to know is ther enay way to convert the paralllel jobs into the server jobs
and i understood your logic that i am not using paralleism and pieline concept so better to go with server jobs.

i am runing the jobs in bunches
so for 29 files i have created 5 jobs each containing 6 oracle to xml input stage

HI All i am extracting the records from 29 oracle tables and creating the 29 xml file then merging the 29 xml file into one xml file through unix script then zipping the merged file and doing the sftp through unix script currently my job is taking around 30-40 sec (depends upon the data in table) to...

thanks kiran its working fine for me now

what if i want the output in the format mm/dd/yyyy

yes i agree it is in the same format please take a look one more time

Hi i have input field as 09062007 and the output is the date format i am using the string to date function StringToDate(DSLink3.col1,"%dd-%mm-%yyyy") but in the output i am getting "**********" and similarily for one field i need to convert the same input to timestamp but it is a...

I think it depends upon your requirement
how is your data
is it changing frequently(every day) .
or it is changing not so often(in a month/quaterly...etc)

please elaborate little more how you are calculating the percentage in output?
for first row it is 100%
in second row it is 80 %(the keys are matching but values are not matching)

i have used the same situation in one of my job it is working fine .

Convert(char(10)," ",DSLink.columnname)