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.
Limit of Stage Variables in version 8
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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 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 ...
Divya
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do you really want partial substitution?
Do you really want partial substitution?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?
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"
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
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
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.Sreenivasulu wrote:My description of 'circular strain' was as ray wurlord describer 'the output of svone being used as an input for svtwo'
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers