DSXchange

DearAll

In transformer stage constraint I am using the following condition by passing a value ,through which the data is segregated and populated in a file. This value must be parameterised. I am using this in transformer stage constraint.How to Do this.

Example : Month=12

This "12" value must be passed as a parameter, as this changes every month.

Look into the Manual or go to a training session.

i agree with WoMaWil , where the code is to be put in constraint of transformer stage to populate values in target seq file according to your parameterized month value.

Do I have to use Data Element or Month.tag.
Give a some suggestion so that I can search or proceed through the method.

tkbharani wrote:DearAll

In transformer stage constraint I am using the following condition by passing a value ,through which the data is segregated and populated in a file. This value must be parameterised. I am using this in transformer stage constraint.How to Do this.

Example : Month=12

This "12" value must be passed as a parameter, as this changes every month.

Just declare a parameter say Month_param and use is in the constraint as

Month = Month_param.

Whats the difficulty in this?

Is the column what used for the constraint is it an integers (for example: 1, 2, ----, 11, 12) or it is a date column?

If the column being reference in the constraint is integer the suggestion provided above should be followed.

If the column being reference is a date then use the code below to fetch the month number. There are methods of achieving the same result.

Oconv(Iconv(Inp_Data.Date,"D2/"), "DM")=pMonth

pMonth is the job parameter.