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. "
standardization stage warnings
-
- Participant
- Posts: 29
- Joined: Sun Jul 22, 2007 3:25 pm
standardization stage warnings
Vijaya K Dasari
-
- Premium Member
- Posts: 62
- Joined: Tue Dec 07, 2004 7:41 am
- Location: Brasil
- Contact:
Re: standardization stage warnings
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..
- 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..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 62
- Joined: Tue Dec 07, 2004 7:41 am
- Location: Brasil
- Contact: