DSXchange

Hi,

A junk character '�' sometimes get attached in front of varchar fields.
Like 'Datastage' loaded as '�Datastage'

How can I remove it in the job.

Regards,
Arnie

id
111
111
111
111

required result
id
111
9110
9111
9112

Hi,

This is in one field and no commas.

it comes in rows.

Hi,

I want to get rid of any number of duplicates.

example.

111,111,111,111

should be
111,91110,91111,91112

There can be any number of duplicates.

Please suggest.

Regards,

Hi

I have a requirement where if the description is "abc /1 ml" or "abc/ml" or "abc/1ml @ 10 min" then I need to multiply the other column i.e the value to 100.

Please suggets. Is it possible in transformer??

Regards,
Arnie.

Hi, I have requirement where if the record are 1,15,201...then the output should be 1,15,501....that is if the number is 3 digit then the 1st digit needs to be changed to 5.

Please suggest....

Thanks...

Well I broke the job in to parts.....from the db to a seq file and then from that file I was able to extract and perform the operations like lookups,sort etc.....was very strange....wonder what can be the reason!!....

it is an extract job....extracts from a table.. contains few lookups and a sort stage...and loads into a sequential file....

Hi,

I have a job that was working OK until now. Now it just keeps on running and shows no rows being extracted. In director, it is stuck at this line:
DSD.BCIConnect call to SQLConnect returned informational message

What can be the reason....please suggest.

Regards,
Arnie.

Hi ,

I have a requirement where I need to get the last word after space..e.g:
from ABC XYZ I should pick XYZ and from ABC XYZ ASD I should pick ASD....

Please suggest...
Regards,

Thanks..it works

Hi ,

How would I change lastname,firstname to firstname.lastname
Please suggest.

regards,
Arnie.

Thanks...it works....

Regards,
Arnie.

Hi I have a requirement where
A1 will become A001
A13 will become A013

Please suggest how to get this.

Regards,

ok here is the scenario that confuses me .... In my job I am reading from a file and looking up with target table to get the max of sequence no and generation max+1 and then loading in the same target. That job was running well untill yesterday(now not running). for testing purpose I broke the job i...