Constrain
Posted: Mon Oct 27, 2008 5:14 pm
Hi All,
i have a constrain in the transformer which allows only the values like "ABC" from a column.(e.x user_defined_routine(dslink.col1) ="ABC") no reject link is present. this was working fine. when i moved the job to test server i changed the input link name from "dslink" to "cd_input_link" and forgot to change it in the constrain.now the problem is that it is not showing error.it is compiling good witout any errors and running fine.but my table is getting updated with current datetimestamp for all the rows.which it is not suppose to happen it has to update only the records that have value of "ABC" from input col.am not able to understand how it is still working even though the link is not defined anywhere in the job. can u guys please throw some light on this and help me understand where it is going wrong..
Thanks
kris
i have a constrain in the transformer which allows only the values like "ABC" from a column.(e.x user_defined_routine(dslink.col1) ="ABC") no reject link is present. this was working fine. when i moved the job to test server i changed the input link name from "dslink" to "cd_input_link" and forgot to change it in the constrain.now the problem is that it is not showing error.it is compiling good witout any errors and running fine.but my table is getting updated with current datetimestamp for all the rows.which it is not suppose to happen it has to update only the records that have value of "ABC" from input col.am not able to understand how it is still working even though the link is not defined anywhere in the job. can u guys please throw some light on this and help me understand where it is going wrong..
Thanks
kris