DSXchange

saj wrote:It is showing the transformer but not the oracle stages .....

Sorry, forgot that it only shows active stages.

Then you'll need to post it in the correct forum - the Enterprise Edition / PX forum - to get the proper help for your issue.

Let's go back to the basics - do you have an Oracle client installed on the DS server? Have you configured DataStage for Oracle?

So... this is a Metadata Workbench issue?

I'm lost... did you add the second transformer or not? If you did, did the list of stages work properly? I'm not expecting it to change the behaviour of the job itself, I'm hoping that adding it lets "-lstages" see everything.

Add a transformer between the source Oracle stage and the hashed file, see if that helps.

Q.E.D. :D

A long standing... "issue" at the very least, bug perhaps. The poll on the home page is related to this issue and has been there for a hell of a long time. Hopefully, the revamped DSXchange site would solve that - if it ever sees the light of day. :wink: I know that if things hang after I ...

A long standing... "issue" at the very least, bug perhaps. The poll on the home page is related to this issue and has been there for a hell of a long time. Hopefully, the revamped DSXchange site would solve that - if it ever sees the light of day. :wink: I know that if things hang after I ...

No clue... have you run these errors by your Teradata DBA? From a quick google, the second message makes it seem like the "enable dbc logons" option is active. And by "enable" it means "enable only".

PhilHibbs wrote:*p.s.* I've been getting a lot of double-postings recently, and I've seen the same from others - not seeing this on any other forums.

Yah, it happens alot and if the original poster didn't notice and clean it up themselves, I do.

That is the way. What exactly do you mean by "it is not providing the oracle stage info"?

As Ray noted -

Sounds to me like something you should be referring to your official support provider. What version of 8.x are you running? Are you current on your fix packs?

Define "not working".

May not really matter as, unless you have a great deal of intelligence built into your "split" logic, all you'll have after the split are smaller useless XML file fragments. What are you planning on doing with these pieces?