Hi ,
The below function is working fine in Basic Transformer but this job is behaving strange sometimes.
Convert(lkMoveConvertData.LKP_REC,Space(256), lkMoveConvertData.SOURCE_REC)
I tried the same above function in regular transformer but it is not working.Does anyone know the reason why the same convert function is not working in regular transformer.
Thanks,
Chris
Regular Transformer Issue with convert function
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 194
- Joined: Thu May 11, 2006 9:42 am
Regular Transformer Issue with convert function
Thanks,
Chris Jones
Chris Jones
-
- Participant
- Posts: 194
- Joined: Thu May 11, 2006 9:42 am
Regular Transformer Issue with convert function
Hi ...Thanks for ur reply.
I am not getting any error.Job is running fine but convert function is not working due to some reason.
thamks
Chris
I am not getting any error.Job is running fine but convert function is not working due to some reason.
thamks
Chris
v2kmadhav wrote:could you please paste the exact error that you get when you try that in a regular transformer.
cheers
VM
Thanks,
Chris Jones
Chris Jones
-
- Participant
- Posts: 194
- Joined: Thu May 11, 2006 9:42 am
Regular Transformer Issue with convert function
Only ONE Source.See the sample job structure.My aim is to convert all the special or ASCII Characters coming in source to spaces.
LKP_REC(lookup..All special or ASCII Characters are present in this lkp)
|
|
Source(SOURCE_REC)-----> ---->Transformer--->Target
Thx,
Chris
LKP_REC(lookup..All special or ASCII Characters are present in this lkp)
|
|
Source(SOURCE_REC)-----> ---->Transformer--->Target
Thx,
Chris
v2kmadhav wrote:are those two fields coming from two different sources?
if you try joining those two sources and look at the data outside datastage....
do you find them to be identical?
what characters are they?
Thanks,
Chris Jones
Chris Jones