DSXchange

How are you assigning the values to the parametr set, PS work differently. Th values are alreday defined and one needs to pass the value file name in the script when calling the parameter set.

The order of defining the sort keys and the grouping keys in the Aggregator stage should be same.

pravin1581 wrote:RCP is not on.

Any suggestions .

RCP is not on.

Any replies will be appreciated.

By now (491 posts) you should realize that we need exact error messages. Without these we're wasting time guessing. Oh, and disable operator combination before capturing the error messages, so that ... The warning messages are :- Sort key <key name> no longer exists in the dataset schema. It will b...

Hi All, I am getting warnings like sort key no longer exists and it will be dropped from the inserted sort merge collector. This warnings are generated for all the sort keys. The design of the job is there is an input link, data is sorted and hash partitioned in the sort stage, then same partitioned...

Sainath.Srinivasan wrote:Did you try 'record delimiter = none' ?

Tried out all the options but cannot get rid of the warning.

How do you intend to use this file in the downstream process ? In the place you read the file, mention record delimiter as 'none' and work with the plan that there is an extra comma. No need to worry about it. I have tried all the different options while reading the file in the next job, but it alw...

ray.wurlod wrote:So put the "trim the trailing comma" logic into the first job. ...

I am getting the comma separeted values when I am collecting the data in the file in the first job, hence I cannot trim the trailing comma there.

Isn't that what you asked for ? Trim the trailing comma. When I am trying to read that file in a separate job where I can trim that trailing comma, i am able to trim the last comma and getting the desired output but the job throws warning like Missing Record delimiter '''', saw EOF instead, and mor...

pravin1581 wrote:

Sainath.Srinivasan wrote:Read the source and write an output with record delimiter as comma

Thanks Sai. I tried this , the output is coming as 1,2,3,4,

Any help will be appreciated.

First thing you need to do is make the job sequence as multiple instance one, that you can set from the Job property and then you can run as many instances as you want, but the invocation id passed shld be separate for separate sequences.

Sainath.Srinivasan wrote:Read the source and write an output with record delimiter as comma

Thanks Sai. I tried this , the output is coming as 1,2,3,4,

arunkumarmm wrote:Or even in a simpler way, create a stage variable like this:

sv1 = sv1 : ',' : InputColumn

and map it to the target column derivation.

The last output row will have all the values...

This doesn't works . The output is coming as 0,0,0,0,