Hi, I have a reqirement to apply buissness rules on incomind data,firstly i have to perform a null check which i have done using a conditional split.Secondly i have to check lenth and precision of some columns,if they exceed some specified limit reject them.I need help to perform the second operation,Please advice Thank you in advance

you can do this using the same conditional split.-------------------------------------------------------- Surender Singh Bhadauria My Blog

Can you please eloberate on this

Cast the numeric value to String then split the string on the basis of the location of decimal point and then check if it fits your requirement or not. It will be a complex expression. another option is use a staging table and set it as the destination. in this staging table keep the constraints on your columns as per the business need. so now the records that dont meet your requirement will cause an error. redirect these records through the error data row path. refer my blog for redirecting error rows. http://bimoron.blogspot.com -------------------------------------------------------- Surender Singh Bhadauria My Blog

Thank you so much Surender for the blog reference ... I think this is gonna work am working on it