DSXchange

I using standardization stage to standardize name and addresses.
Below warning message I am getting in director.
"
Stan_Cust,1: 'ANGELLFAMILYTRUSTPERRYORETZKYSUCCESSOR' exceeds maximum length of 20 for output field MatchPrimaryNamePackKey. The data will be truncated.
To prevent this warning, modify rule set USNAME and increase the width of dictionary column MatchPrimaryNamePackKey. "

How to modify rule set USNAME and increase the width of dictionary column MatchPrimaryNamePackKey. "

In DataStage Designer..

- Go to "Standardization Rules"/USA/USNAME.
- Open file SET USNAME.
- Rule Management will open. Open dictionary file and look in "Matching Fields" block and will see MatchPrimaryNamePackKey column.
- MAKE BACKUP of this content.
- The information "20" in this line is lenght.. change this and the below others lines, keeping a same logic.
- Save the file.
- Test the modification.
- Do a provision (right click in rule)

Reload the rule in Standardize Stage (in job) and execute..

And finally, post ur report..

Isn't the USNAME rule set read-only?

ray.wurlod wrote:Isn't the USNAME rule set read-only?

I don't remember of this, because rarely use this rule set.
Anyway, do a copy for develop a rule customized.