The reference tables coming wiht any country specific rulset: Are they used for both standardization and matching or one of them?
In Mexican rulset, a regular entry for a Reference Colony table is
"ANDRES CUEXCONTITLAN"
MXASENTA 850
The presence of 850 reflects that this file would be use for matching.
Is the file also used for standardization?
Usage of reference tables
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
Only for Standardization ...the 850 is used to indicate that uncertainty comparisons will be used so you don't need all permutation of the string
By the way each entry in your lookup table is in one line, right?
Like this:
"SITIO EJIDO" MXASENTA 850
By the way each entry in your lookup table is in one line, right?
Like this:
"SITIO EJIDO" MXASENTA 850
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
JRodriguez wrote:Only for Standardization ...the 850 is used to indicate that uncertainty comparisons will be used so you don't need all permutation of the string
By the way each entry in your lookup table is in one line, right?
Like this:
"SITIO EJIDO" MXASENTA 850
No it is two lines like
"SITIO EJIDO"
MXASENTA 850
Also, when i removed all the added entries to the "new imported rulesets( renamed, provisioned, etc", then the job is runnign as usual.
Divya
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
Would you try to align each entry into one line? Probably that's the issue
Last edited by JRodriguez on Tue Jun 23, 2009 12:43 pm, edited 1 time in total.
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
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact: