DSXchange

Hi Group, I am doing a comparative study of informatica (PowerCenter 6.2.2 ) and Datastage (IBM Websphere DataStage Server Edition 7) to decide on which Tool to use for next project (Simple ETL for loading data in BO universe). Can some body help me in A)Pls Point me to some good sites for informat...

Since Halloween took up most of my day, I didn't further Ray's comments. Changing out the RDBMS for OCI is worthless, as I believe that they both use sqlnet anyway, so there's no performance difference. I could be wrong, but even if someone said ODBC for OCI for performance reasons I'd say whoopee. ...

Sorry about not responding, you know, Halloween and I've got 3 crumb crunchers. I took some nice digitals of my handiwork. Anyway, the OP has only two projects, both inaccessible, with a different error message per project, acting up since yesterday. Given that scenario, it seems reasonable that the...

Do you mean after you un-protect the project? Yes. While protected? No, hence that 'Protected' part.

You seem to be dancing around and not specifying what problem you are attempting to handle. Share some more info??

No, look for your improvements in the design.

Make sure you do a folder copy of all of your projects to somewhere safe. When you do the DSEngine reinstall, it hopefully will pickup your existing projects and everything will be fine. If not, a REINDEX may fix it after the reinstall. If that doesn't work, we can try to walk you thru copying the s...

Run it and supply an invocation id, don't run the base job. You won't get a number, you'll get what you used as the invocation id.

Make sure your project file system is not out of disk space. Did someone change the permissions on the DSEngine files? Just so you know, here's a post that gives you the grim news: m Odds are great that somehow you've corrupted the DSEngine. The easiest things to do will be to re-install DataStage e...

What you want to do is make a copy of the directories that hold the project information to a backup area. We have some capability to reconstruct a project as long as we have the project information. For example, we can tell you how to recreate a project after a corruption by copying internal files a...

Before you do anything else, are other projects still working?

Any chance you're out of disk space on the server engine or project file systems? These types of errors with "UNABLE TO LOAD SUBROUTINE ON HOST" have come previously when users corrupted their installation, changed permissions on the engine files, or ran projects out of space. The obvious questions ...

You pay by the server licenses, cpu count, the number of client users, the initial training, startup consulting, maintenance fees, bundle discounts, etc. There's no price schedule, it's all negotiated. You should read DMReview, as in the past they have done comparisons.

No. You will need to trim any data that comes out of a fixed width file. Look into mass adding TRIM to every derivation on a transformer immediately after the source sequential file stage. If you open help on the Transformer, you'll see a column propagation ability, where you can highlight all of th...

Get rid of the spaces before and after the "=" sign as well as the code value, it messes up the logic. It works only if it looks like this:



You really should be more careful, this is fairly sloppy coding, IMO.

Yep, Ray's correct. I was thinking too many things when I typed the post. You probably are passing a non-numeric value into a mathematical expression, or you are passing a NULL value to a function that is not prepared to handle it. Should have just been You are passing a NULL value to a function tha...