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.
"Transformer Stage Constraint" to be parameterised
Moderators: chulett, rschirm, roy
Look into the Manual or go to a training session.
Code: Select all
Month=pMonth
Wolfgang Hürter
Amsterdam
Amsterdam
Re: "Transformer Stage Constraint" to be parameter
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.
-
- Participant
- Posts: 132
- Joined: Wed Mar 01, 2006 11:12 pm
- Location: Pune
Re: "Transformer Stage Constraint" to be parameter
Just declare a parameter say Month_param and use is in the constraint astkbharani 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.
Month = Month_param.
Whats the difficulty in this?
SMB
-
- Participant
- Posts: 3
- Joined: Tue Oct 23, 2007 11:57 pm
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.
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.
Masters are never born. But they become one by experience.