DSXchange

Hi,

There is a requirement where i need to use a constant to declare the number of weeks. How can this column be populated as this needs to be used in a transformer with the incoming columns of source?

I think you can use a jobparameter for doing this.

If you want to hard code the value means is the value will constant always then you can put the constant value in Transformer or you can try with the row generator.

But if the value is constant for some time( Like if you want to change for each run then you can go with the job parameter)

Thanks,
Birendra

In a stage variable initialization expression, a stage variable derivation expression, an output link constraint expression or an output column derivation expression just use the constant (for example 52).

If it's not really a constant, then use a job parameter.