DSXchange

If the website has a service you can leverage, then the "real time" stages could be used. Never made any attempt to use the Java pack or source from an HTTP server so can't really answer the other question.

Another option, depending on exactly what you are after in the column and how it was built, are the built-in Oracle functions for working with that particular data type.

Split out to its own post.

Manoj, please edit your post and include your relevant details: O/S, version.

ray.wurlod wrote:Enclose your ASCII art in Code tags so that the spacing is preserved.

Like so.

Please start your own thread with the details of your particular error message.

As far as I know, the Java Pack is the only way to go.

Misplaced Transformer fear, I'd wager.

Not in a Server job, I'm afraid.

So... what "few steps" did IBM send you? Anything worth sharing? I had nothing to add, not having had any personal experience with an error like that and didn't understand how any kind of 'permissions' error could be resolved (even temporarily) by recycling the DataStage services, so figur...

You uninstalled the 7.5 client and part of the 8.1 client as well. The MCM dynamically switches ddls and even shortcuts from what I recall, rather than just 'pointers' or whatever else people might think is going on. It makes one or the other client the 'currently installed' client and thus part of ...

... or you can use a Transformer. 100% reliable.

Change "would need to" to "could" in my previous post.

"Read link private caching enabled, cache size (128MB)" is the "preload is happening" message I was looking for. Sorry, haven't had any kind of DataStage access for the last year so doing this all from memory. Or what's left of it after going to Informatica Re-education Camp. :wi...

Thanks for the picture. By "successfully" do you mean the link between DRS stage and hashed file is green? Then yes. No, I mean you look in the log and see what entries are there for startup of the hashed file stage. It should mention the fact that the preload is happening and then another...

Sorry, but your terminology still confuses me. :? "Every lookup to DRS stage has a hashed file stage in between" So, in spite of the fact that you've said (for example) Trans3 has 6 lookups, 4 from DRS stage, there are in fact no lookups directly against a DRS stage? All lookups are being ...

Post your constraint. And where in the Connector is your DDL?