DSXchange

Thanks Paul for the link and we have forwarded it to our Admin.

We are trying to import some jobs (from .dsx files) and the jobs are trying to import to a specific folder that seems to have been accidentally locked by us. My questions are: 1. How to change the folder to which the jobs get imported ?(we are importing the jobs using the 'Import' option in the Data...

You are right, Craig. My bad as I wanted it to be "reset if required, then run".

Thanks.

The summary log is posted and please let me know if a detailed log is needed too. Thanks. Occurred: 4:31:17 PM On date: 8/2/2012 Type: Info Event: xfm_IntlFreXtract,10: Numeric string expected . Use default value. (...) Occurred: 4:31:17 PM On date: 8/2/2012 Type: Fatal Event: main_program: ORCHESTR...

Hello,
We have a sequence of jobs and one of the jobs in the sequence starts and gets completed successfully but does not do any processing. It is like the job starts and completes and skips all the stages in the middle.
Any suggestions on why this might be happening is greatly appreciated.

Thanks.

Thanks Craig. I will look into the DSJobInvocationID macro. But , I guess my membership has expired and I am not able to look at your full post.

Thanks.

Hello, We need to run a sequence of jobs and each job in the sequence has to be run for different parameters. The sequence need not be run in parallel and can be run one after the other for different parameters. We would like to append the parameter to the output file name after each job in the sequ...

Thanks Craig and Ankur. I have implemented the following and performing some testing. if(Mod(Decimal,Integer) >= Integer/2) then AsInteger((Decimal/Integer)+1)*Integer else AsInteger(Decimal/Integer)*Integer The problem occurs when my Integer rounding value (which was assumed to be 5 earlier) turns ...

Nearest can be either direction.

2742.334566 with 5 for the multiple would go down to 2740.

Thanks.

Hello, I need help on rounding a decimal value to the nearest multiple of the given integer. For example, if the value is 2747.334566 and the given integer is 5, the value must be rounded to 2745. If the value is 2748.23456 and the given integer is 5, the value must be rounded to 2750. Any help is g...

OK. Thanks.

Hello, What is the best method of identifying records that generate warnings/errors? We have millions of records as input and we implement the StringToDate() function and some records generate the following warning in the log: Conversion error calling conversion routine date_from_string data may hav...

I looked at the solution provided in the following thread: http://www.dsxchange.com/viewtopic.php?t=145258&highlight=vertical+pivot I was under the assumption that the LastRowInGroup() funtion in a Transformer stage will work on more than one input column concatenated together. But, looks like m...

Which version of DataStage you are using?

My version is 8.7.

Any concern on null fields for groups having less than 4 rows?

The transposed data must have four columns for each group with the value being NULL for any missing rows.

Thanks for the suggestions and I will try them out.

Thanks Ray. I had one more questions. According to the requirements, the number of rows can be between 1 and 4. For example: Column1 Column2 Column3 Column4 Column5 Row1 a b c c1 1000 Row2 a b c c2 2000 Row3 a b c c3 3000 Row4 a b c c4 4000 Row5 d e f c1 5000 Row6 d e f c3 6000 Row7 d e f c4 7000 Th...