Transformer stage - constraint
Posted: Wed Dec 06, 2006 10:12 pm
Hi,
I have a job in which i read a source file which has about 100 records and this is passed to a transformer.in the transformer, based on the i/p column value the row has to be moved to the appropriate datasets.
In the above job, i give two constraints on the transformer stage, if i/p column =a, dataset1 and if i/p column =b, dataset2.
the problem is, when a new value for this input column is coming in, for eg., c, then the source is not reading that value at all. wheres the prblm?
the job structure is :
source -> transformer -> target
Thanks
I have a job in which i read a source file which has about 100 records and this is passed to a transformer.in the transformer, based on the i/p column value the row has to be moved to the appropriate datasets.
In the above job, i give two constraints on the transformer stage, if i/p column =a, dataset1 and if i/p column =b, dataset2.
the problem is, when a new value for this input column is coming in, for eg., c, then the source is not reading that value at all. wheres the prblm?
the job structure is :
source -> transformer -> target
Thanks