Data cleansing functionality
Posted: Thu Dec 04, 2008 3:07 pm
I need a generic cleansing functionality.
It sounds like this:
When the field value is empty or Null then if it is an Alphanumeric (Varchar and such) field then default it to Null, if it is numeric field, then default it to zero.
It is easy to code, but I do not want to code it for every field in every job.
I would like to have a stage to which I may have any input and output and get the work done.
Does anybody know how to create this (custom or buildup)? Or may be somebody have something similar already.
Thanks.
It sounds like this:
When the field value is empty or Null then if it is an Alphanumeric (Varchar and such) field then default it to Null, if it is numeric field, then default it to zero.
It is easy to code, but I do not want to code it for every field in every job.
I would like to have a stage to which I may have any input and output and get the work done.
Does anybody know how to create this (custom or buildup)? Or may be somebody have something similar already.
Thanks.