DSXchange

When you imported the table definition, what data type was detected/selected?

You're using a 12 hour clock in your value but at 24 hour clock (HH24) in your date format picture. That's almost certainly why it's not working. Your date picture does not match the string date format.

Handy, that Search functionality!

Use one job, with a schema file (whose pathname is passed as a job parameter) to describe the structure and Runtime Column Propagation enabled. Pass the file name and the Oracle table name as job parameters also.

Fork-join (twice) with two Aggregator stages.

There's no such thing as junk characters. They are your client's data. If they're in the source database, they're valid, and you have to move them. First step is to find out what they actually are. When you've posted that, we should be able the help further.

DSXchange is not a mobile phone. Will you please stop using SMS-style abbreviations?!

Yes, the function is Alpha(), not IsAlpha(). It returns a true/false value depending on whethe the string consists wholly of alphabetic characters.

What were the default settings (Tools > Options) in Director when you scheduled the job?

Read the second paragraph of my earlier post again.

Why do you specifically want U (one of our posters) to help you?

The second person personal pronoun in English is spelled "you".

Welcome aboard.

I can not answer your Oracle features not working question, but your existing version 9 Oracle client software will happily communicate with an Oracle 10g instance.

It is possible. This is precisely what the Pivot stage does.

Is this the word "NULL" or a true NULL ? Because anything concatenated with a true NULL leads to NULL as the result. If it's a word, then your Ereplace() solution should still work.

It is very unusual that isadmin has been given any DataStage project role. Perhaps a different user should be used. Are DataStage credentials set up correctly in Web Console?