DSXchange

Welcome! :D Are you running the client on Windows XP with Service Pack 2 (SP2) loaded? If you are, have you loaded the DataStage Client SP2 patch? That sounds like one of the symptoms the SP2 patch corrects. If you need the patch, you'll need to log onto Ascential's eServices website and go to the D...

You could also check out Chuck Smith's utilities: http://www.anotheritco.com/tools.htm

In particular the 'List all files and tables used by jobs in a dsx file' tool, aka DataStage job.

Best to post questions like that over in the SOA forum. As I said, it allows you to publish a job as a Web Service with a choice of different bindings - SOAP over HTTP, JMS and EJB from what I recall.

Use Erplace or Convert in the transformer you will be adding between the ODBC and first Sequential stage on the field or fields in question. You can either replace the character ( CHAR(10) ) with something else like a space or delete it.

Hi Craig, There are secutrity tools you can install on the server. the System Gals in the site I'm located right now (solaris) have put a ZEOS (Ithink it's called) security server that will constrain ussage and access on a per user basis. It also knows your original login for the session and will u...

Can't you just use Unix's group policy's to enforce this? If that user isn't in the right group they don't get in, or am I missing something here. No, it goes way beyond that. A 'valid' user with valid group permissions should be turned away if that are not connecting from an 'approved' server. Gre...

Thanks for the thoughts so far. I'll pass along the ZEOS suggestion and see what comes of it. As to the Manager issue, Arnd, not sure if that would be a problem or not. Generally, the only way that objects get into the Production server is via Version Control. We'd still have 'normal' access to the ...

Curious if any folks have faced this situation and what, if anything, they've done to solve it. We're going through mock SOX audits in prep for the Real Thing and the peoples in charge of that here are worried about limiting 'ETL production access'. This means only certain people should be logging o...

They become truly 'real time' when you use them in an SOA enabled job published as a Web Service. Yes, that means you have to purchase the SOA Edition, so the category is a bit of a misnomer out of the box.

Looks like it can still be an issue in 7.x - see this post - but I couldn't find any mention of a resolution.

Probably best to open a support case with Ascential.

ak77 wrote:Now the question is how it affects the processing if the table definition is not in the DS-Repository?

It doesn't. Look elsewhere for your performance difference.

Ah... 390. Was pointing that out because that version has a stage that is actually called the 'Conditional Lookup' stage.

It's a plain text file on a UNIX server. The OP is on Windows.

Ok. I don't often use them, so I'll profess a level of ignorance as to their best practices. Since you can't use a single stage - link in and link out - to do this, I'd be curious what a single job design would look like that leverages named pipes. Would you have two completely separate streams - on...

ray.wurlod wrote:Conditional lookups are fully supported in the parallel Lookup stage. Who was asleep during class?

Hey, we weren't discussing parallel jobs. Besides, it was too flipping cold to fall asleep... well, except maybe from hypothermia.