DSXchange

By 'NULL', do you actually mean @NULL?

Don't even consider Option 1... it won't work. Go with some variation of Option 2. What 'hashed files used in the project' are you thinking of copying over? Persistant data, not something that could be easily recreated over in the new project? Someone else can chime in, but I seem to recall some 'uv...

Select the 'Aggregate all rows' Output mode on the Transformation Settings tab.

Actually, I think it's a very easy task to accomplish. You can complicate it if you like, but it really can be distilled down to one job that creates three separate files and concatendates them together when it is done. Easy Peasy.

In other words, if you have the 'Extended Job View' option enabled - turn it off.

1) Yes, of course.

2) No, not at all.

3) Depends on the job, some would obviously be 'more easier' than others to convert. It's generally not considered a simple task, but I'll let others who have actually tackled that speak to it.

For 'large' volumes - yes. It can also depend on what your threshold of pain is for an OCI -> OCI run, one man's too long is another man's okay.

A view is just a logical construct that treats a result set like a table, and yes it can include more than one base table. It's already 'pre-joined', it's nothing you need to monkey with... all you may need to add are additional filters in the where clause you use to access it. If the joins are inap...

Have you checked out people like the Gartner Group?

I would gladly pay you Tuesday for an RMM stage today.

Pervasive? That's a new one on me... I thought you meant one that 'has the quality or tendency to pervade or permeate'.

Just curious... when or is this coming online? Or is there someplace else here I've missed that people can upload stuff to share?

Thanks!

As noted, your 'mobile' is just another email address. For example, for someone on Sprint PCS here in the US, you would send a (hopefully) short email to 'phonenumber@messaging.sprintpcs.com'. Others are very similar.

It's not always about how Big and Beefy your server is, or the number of jobs running at the same time - it can be about the number of jobs you try to start at the same time. Your 'abnormal termination' errors are a separate issue. Suggest you start a new thread and include as much detail as you can...

Suggest you get yourself over to ADN (sign up if you haven't) and download the XML Pack Best Practices document from there. If is extremely helpful in general for dealing with XML in DataStage and includes a specific section on handling multiple repeating elements.