Data Cleansing Strategies
There are serveral methods for data cleansing:
| Cleansing Strategy | Description |
|---|---|
| Remove | Does not populate the target table with error records |
| Custom | Custom function in the target table |
| Set to Min | Sets the attribute value of the error record to the minimum value defined in the data rule. |
| Set to Max | Sets the attribute value of the error record to the maximum value defined in the data rule. |
| Similarity | Uses a similarity algorithm based on permitted domain values to find a value that is similar to the error record. |
| Soundex | Uses a soundex algorithm based on permitted domain values to find a value that is similar to the error record. |
| Merge | Merge duplicate records into a single row. |
2 Comments
→
Hi, just hoping around some blogs, seems an exceptional program youre making use of. Net marketing from present making use of WordPress blogs for several associated with the internet sites nonetheless wanting to adjust certainly 1 of them to the web page a platform significantly like your own to be a trial run manage. Nearly anything specifically you would advise over it?
There are various threads in the marketplace in close proximity to the following, I believe choosing certainly, there guide can encounter decided to get this to identify or perhaps content actually insightful. Realistic objective manifestation this post is unhealthy. Basically I need to articulate what sort of information and facts supplied at this point was initially one of a kind, purely improve much more all-around complete, promoting and also other ex – information have ended up essentially superior. The elements you’ll appreciate carressed allow me to share necessary, thus I really undoubtedly will certainly position some of the information and facts below to create this really just the thing for altogether this newbie’s below. Thanks this info. Actually helpful!