This is a doubt regarding OFFICIAL activities of cleansing.
I have few data fields like :
Place of Birth
RFC ( a kind of identification but not a very important one)
CURP ( a kind of identification but not a very important one)
etc
The client requirement is to remove the special characters from the above fields in general. No other requirement mentioned.
Is the cleansing of the above fields possible by using some Quality Stage funcationality? Or it shuld be done by Data Stage only?
Quality Stage Cleansing!!
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
DivStand ..
This can be done in both tools .. but if you suspect that new terms will be coming in the future or the list of terms is long then I would used Classification Overrides ...just assign them the nulls class.
If just a couple of them using a transformer before the standarization stage and replace function will do the trick for you
This can be done in both tools .. but if you suspect that new terms will be coming in the future or the list of terms is long then I would used Classification Overrides ...just assign them the nulls class.
If just a couple of them using a transformer before the standarization stage and replace function will do the trick for you
Julio Rodriguez
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses