Hi
Another Matching question:
Looks like it is not a good idea to block on null columns?
Example:
MatchColumn1 MatchColumn2
CompName B
CompName
CompName C
The above result will be that no blocking is done.
The only way to get it matched is using the following:
Block on MatchColumn1 and do the matching
on MatchColumn2, Critical missing ok.
Is that correct?
Shouldn't it be possible to block on null values?
Regards
Dale
Blocking
-
- Participant
- Posts: 20
- Joined: Tue May 13, 2008 1:24 am
- Location: Dale Cooper
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
Dale,
All records containing nulls values in columns that are part of your blocking criteria become residuals, but will be available for next passes where you can have a different blocking criteria using other columns
It is always possible to handle nulls values in any previous step (standardization ?) and default a value for any nulls...
All records containing nulls values in columns that are part of your blocking criteria become residuals, but will be available for next passes where you can have a different blocking criteria using other columns
It is always possible to handle nulls values in any previous step (standardization ?) and default a value for any nulls...
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
-
- Participant
- Posts: 20
- Joined: Tue May 13, 2008 1:24 am
- Location: Dale Cooper
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
Dale,
All records containing nulls values in columns that are part of your blocking criteria become residuals, but will be available for next passes where you can have a different blocking criteria using other columns
It is always possible to handle nulls values in any previous step (standardization ?) and default a value for any nulls...
All records containing nulls values in columns that are part of your blocking criteria become residuals, but will be available for next passes where you can have a different blocking criteria using other columns
It is always possible to handle nulls values in any previous step (standardization ?) and default a value for any nulls...
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