DSXchange

Hi, I have same DSX in prod and DEV. But while selecting any value from DUAL in prod it is padding some space where as in dev it is not. I can ensure no change in DS jobs. Could someone put any light what could be the issue?

Are these actually Server jobs? Do you have this issue with all Oracle sources or just literally when you select something from DUAL?

Yes, this is a server job. We are getting this issue while doing a look up (Oracle -- >Hash File-->Transformer) and the field is CHAR(2). Then we tried to simple querying DUAL table to select any value and see the issue is PROD version is adding extra spaces where as DEV is not. I am not sure how can i attach an image here else i can send the screen shot. Anyway, thanks for your help.

What is your APT_STRING_PADCHAR set to in each project/environment?

I don't believe that affects Server jobs at all...

Are the two jobs SELECTing the same database? If not, the basic database settings might be different.

Yes, both the databases are same.

'Same' as in exact same database or they are two different databases but set up exactly the same?

Where exactly is this CHAR(2) in your job? I'm more surprised to hear it doesn't get padded with 'an extra space' in DEV than it does happen in PROD. That's the nature of CHAR fields, they automatically pad out to their full size. Parallel jobs have an option to control what character is used for the padding which is why Paul asked his question, Server jobs not so much.

You are going to have to work out what is different between the two environments. Clearly something is.