DSXchange

It is unfortunate that this stage does not support wildcards. I have been using the parallel Sequential File stage recently, which does. Oh well, I guess the Folder stage solution will have to be the one to use.

Running the job gives exactly the same error in the job log that was generated in View Data in all the variants we have discussed.

Using /dev/null as the File name property made no difference; exactly the same error message was generated. Using an explicit file name and just grep ^T~ as the filter worked. Using a file name with an asterisk in the File property and just grep ^T~ as the filter command generated a slightly differe...

I have tried specifying it in the stage with an without double quotes around the pathname. grep ^T~ /home/dsadm/dev/input/Contracts_* grep ^T~ "/home/dsadm/dev/input/Contracts_*" Because the file name is actually ignored, I put DSParams in the File name field. As yet I have only used View ...

I am having a difficulty with Filter command in Sequential File stage. The Filter command works perfectly well when executed in UNIX on the server but does not when from the stage using View Data. Both of the following Filter commands exhibit the same problem. cat /home/dsadm/dev/input/Contracts_* g...

I am having a problem with this function in the Modify stage, and can't resolve it. There is one input column, Frequency (VarChar) and two output columns (Frequency (VarChar) and FrequencyCode (SmallInt)). Specifications are: KEEP Frequency FrequencyCode=lookup_int16_from_string['None'=0;'Suspend'=0...

My apology for not mentioning this. Yes we did reset the job; the only message from previous run was the one-line [Done] message from the phantom process DSD.StageRun, which I understand is the Transformer stage's process.

One of our jobs threw "Abnormal termination of stage transformer_name detected" error in production. The job works in dev/test environments but threw only this error in production - there was no extra information logged and no other errors/warnings logged. Job design is OCI --> Transformer...

I am trying to learn QualityStage by reading the manuals and experimenting. In Pattern Action Reference manual it states that "for each active token there should be one corresponding domain mask in the override instruction, and that the domain mask is the class to use to RETYPE the correspondin...

I am trying to learn QualityStage by reading the manuals and experimenting. In Pattern Action Reference manual the term "POST actions" is used, and the manual explains that POST actions must occur prior to any pattern-action sets (in the PAT file) and are preceded by the line \POST_START a...

Thank you for your replies. We had our Oracle DBA look at explain output and it was found that grouping was less cost than sorting, based on our data. The only reason we would have needed to sort would have been to allow the Aggregator stage to process the volume of data in question. So we are plann...

Put them both in the Input Values field. If you want a comma between them, that is fine. #TargetDir#,#TargetFile# for example.

In the subroutine itself you need to parse out the individual values. For example Field(InputArg, ",", 1, 1) and Field(InputArg, ",", 2, 1).

Can I please have best practice suggestion on this scenario? We have to take an inner join between two Oracle 9i tables, one having 50 million rows, the other having only a few thousand, and then to group by four columns and form sum, minimum or count of six other columns. Some colleagues are sugges...

ICE wrote:Dear All,

Thank u so much.Thanks a lot.
I will try and let u know then.
I really appreciate you all advise.

Thanks a lot..

Please don't let me delay your search for someone who cares.

U is my name.
"YOU" is a personal pronoun.
Please get it right.

You can create routine in designer as well as manager. Open designer, see look for Routine tree in the repository under project. If u don't find there, right clik there and click show routine under popup menu of customization. There u can create server/parallel/mainframe routine. hope it will help ...