DSXchange

Ah... RCP. That would have been good information to include in your first post.

Node != CPU. The former is a logical concept, the latter a physical object. The O/S decides how many actual CPUs to use, not you and not DataStage.

That sounds like a variation on the dreaded "double convert" that we've documented here in the past and you could search for, should you so desire.

Sounds like a parameter set with value files to me. If you are the one calling the web service, seems like you could direct the output there...

Interesting. However, as noted, it should be pretty straight-forward to open the two files and compare them to find where the bloat is coming from. They are just text files after all, so any editor that can handle large files would do the trick. We use UltraEdit / UltraCompare for things of this nat...

I for one would never use an annotation to "cover" any other stage. Not sure what others do but we used them on the canvas somewhat sparingly and more for high level topics regarding the job. For something like what you want to do, 'understand the usage of a transformer', IMHO that should ...

I'm going to guess it's a DataStage issue somehow as, to the best of my knowledge and experience, an Oracle sequence is not capable of issuing any kind of duplicate value. Not that Oracle ever has any bugs, of course.

In your shoes I'd start with your official support provider.

Why not just target a string in the flat file?

That's not float, that is scientific notation and you can thank Excel for that. I imagine you'll have to disable that in the spreadsheet itself.

Welcome. Because DataStage does not recognize an error, when no updates were made, I can't react properly to the SQL operation. For my own edification, not knowing DB2, does the database itself consider an update of zero records an error? I ask because Oracle doesn't, i.e. it will happily and succes...

I don't think your issue with answers is the "CDC Parallel job" part, it's the "always running job" part that complicates things. I wonder if this would fair better over in the SOA/RTI forum?

So it sounds like you'll need to take the list of jobs and iterate through that, running each through dsjob -jobinfo and then parsing that output.

I think a lot of bad habits are made when learning Informatica first. From what I can tell Informatica cannot survive without staging tables. They also tend to use SQL for joins and transforming. These developers are afraid of nulls so they scrub them out in SQL. Very poor. Hey, I resemble that rem...

He already did. Post an example of the output in 8.1 of -ljobs without the status option. Doesn't have to be the whole thing, just a nice little sample will do.

Open the routine to see the source and all will be revealed. I'm assuming the 'DSSendMailTester' routine is still shipped with the product, that would show it as well.