Limit of Stage Variables in version 8

[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.

[divstands]

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?

[ray.wurlod]

You can't, except by providing all partial key values as lookup keys.

[jgreve]

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 

[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

[chulett]

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.