Additions without Transformer

[alkanti]

Hi, Is there any way to increment an integer column by 1 without using transformer stage in Parallel Edition.

Thanks

[ArndW]

Yes. But no method that I can think of is easy to implement and would be silly to use - i.e. putting in a dummy column with a fixed value of 1 and then using some other stage such as a modify to perform the action.

[alkanti]

Can the modify stage be used to concatenate a constant value to a varchar column? or the constant has to be defined as a separate column and then do the concatenation.

Yes. But no method that I can think of is easy to implement and would be silly to use - i.e. putting in a dummy column with a fixed value of 1 and then using some other stage such as a modify to perfo ...

[uegodawa]

You can use Surrogate Key stage to generate values by specify the initial value for the key generation. It defaults to 0. You can also specify a job parameter, so the start value can be supplied at run time.

If you want to concatenate the generated value with constant, you can use modify stage. In modify stage you just need to give the derivation, no need to define extra column. For Example Input Column : S_KEY ; Output Column New_S_KEY then specification for New_S_KEY column would be New_S_KEY := 'Constant' : S_KEY.

[ray.wurlod]

Can the modify stage be used to concatenate a constant value to a varchar column? or the constant has to be defined as a separate column and then do the concatenation.

No. Modify stage functions are single-argument functions. That rules out arithmetic operations.