regarding transformer stage

vijaykumar · Post by **vijaykumar** » Tue Dec 19, 2006 12:56 am

hi Gurus,
i want to give deptno as parameter.
name prompt type value
deptno enter the deptno string 20

the main problem is why it doesn't have default types other than string and encrypted.
as i want to specify constraint in transformer stage.
in the transformer stage--- i want to define constraints. for ex deptno=20 , so that i can catch rejected rows.
dslink6.rejected
dslink4.#$deptno#
iam getting expression invalid.
dslink5 and dslink6 are o/p links.
dslink4 is i/p link.
plz help me how can i define jobparameter, and define this in constraints of transformer stage.
plz help me

cheers;
vijay

kumar_s · Post by **kumar_s** » Tue Dec 19, 2006 1:06 am

If I understand your requirement, you need to either reject the rows with deptno=20 or deptno<>20.
Give it as a constraints, and mark the other link as reject. If you want to parameterize, the value can be deptno = parameter (without any '#').
If your requirement is different, you can specify it again.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 19, 2006 3:50 am

Use the expression editor to construct your expression. You will learn, by doing so, that job parameter references in expressions do not take the surrounding "#" characters. You should also take the time to name your stages and links meaningfully; it helps diagnosis and maintainability.

vijaykumar · Post by **vijaykumar** » Tue Dec 19, 2006 1:01 pm

hi Gurus,
thanks very much.
i could resolve the problem, when i give DSLINK5.DEPTNO=$DEPTNO.
it works fine.
iam marking the topic as resolved.

cheers;
vijay