Page 2 of 2
Posted: Tue Aug 04, 2009 12:16 am
by ray.wurlod
This is your first mention of partial replacement, and with no amplification. The short answer is yes, provided that all partial key combinations are accounted for in the lookup.
Or you could effect a non-equi join in a database.
You do any conversion in a Transformer stage downstream of the Lookup stage.
One stage, one function - this is a fundamental principle of parallel job design.
Posted: Tue Aug 04, 2009 4:38 pm
by divstands
ray.wurlod wrote:This is your first mention of partial replacement, and with no amplification. The short answer is yes, provided that all partial key combinations are accounted for in the lookup.
Or you could effe ...
Yeah... as shown in the example, i will be incorporating all the partial key combinations. But i dont understand how do i specify to check for the availability of the partial replacement using lookup. The Key gives equality, range, etc as the Validation condition. How to make it check for partial existence?
Posted: Tue Aug 04, 2009 5:06 pm
by ray.wurlod
You can't, except by providing all partial key values as lookup keys.
Do you really want partial substitution?
Posted: Thu Aug 13, 2009 5:20 pm
by jgreve
divstands wrote:Yeah... as shown in the example, i will be incorporating all the partial key combinations.
But i dont understand how do i specify to check for the availability of the partial replacement using lookup.
The Key gives equality, range, etc as the Validation condition.
How to make it check for partial existence?
Do you
really want partial substitution?
Or would token based replacement serve you better?
If you do partial substitutions, do you really want results like this:
Code: Select all
input: "Local Localizing Loc Locquacious"
output: "Localidadal Localidadalizing Localidad Localidadquacious"
input: "Unpedro Lopez"
output: "UnTom Lopez"
Would you rather break out the individual tokens,
run them through a lookup-process, and then splice
them back together again?
I'm not saying partial is incorrect - just asking if this is really
the effect you are looking for.
How much data profiling have you done?
Code: Select all
List : possible implementation
Pedro Tom : Replace(Arg1,"Pedro","Tom")
Loc Localidad : Replace(Arg1,"Loc","Localidad")
San Man :
Col Colonia :
...etc...
Hence the string
Loc San Pedro Arriba La Rosa Del CoL de Calle
should become
Localidad Man Tom La Rosa Del Colonia de Calle
Posted: Sun Aug 16, 2009 9:38 am
by Sreenivasulu
You are right Ray in helping me describe about 'circular strain'
My description of 'circular strain' was as ray wurlord describer 'the output of svone being used as an input for svtwo'
Regards
Sreeni
Posted: Sun Aug 16, 2009 10:04 am
by chulett
Sreenivasulu wrote:My description of 'circular strain' was as ray wurlord describer 'the output of svone being used as an input for svtwo'
I think you've got your description backwards, as that way is perfectly fine. I understand what you meant now, even if I think the name is a little... odd.
