- I wanted to have pairs of DETAIL/MASTER in the output (to use JOIN and
SPEC afterwards), so I used the PAIRWISE option of LOOKUP.
And the PAIRWISE option needs the ALLMASTER option, if I correctly read
the LOOKUP diagram.
So I used the ALLMASTER option, even if my reference doesn't have
multiple masters.
"| L: lookup ... DETAIL ALLMASTER PAIRWISE",
"| join",
"| spec ...",
"! > "outputFile,
Is there a better/cleaner way ?
- When you have multiple masters, how do you unravel them after having
joined them with "join keylength" ?
For example, if I have this before the "join keylength" :
a1
a2
b3
b4
b5
and that afterwards :
a12
b345
- Considering your answers, I'll try and be more precise :
Is there an idiom to enrich a big file (which may have several lines
with the same "key") with another reference-file (which can't have more
than one line with a given key) ...
1. ... if the reference file is not too big ?
2. ... if the reference file is big ?
- I looked at your stage, I saw my new friend "not fanout", and "gate"
I'm not familiar with, so I'll need time to digest that one !
Thanks
Michaël
http://rvdheij.wordpress.com/2011/10/05/binary-search-stage/
Sir Rob the Plumber
