DSXchange

Just add the appropriate WHERE clause to the link properties in your database stage - probably on a tab called Selection.

Welcome aboard.

Your "friend" only exported the executable jobs, not the design time information.

There is only one solution, and it is the obvious one.

Informatica is a great tool also (I've never played with Ab Initio). As far as I'm concerned it is a Good Thing that there are two (or more) good tools out there - they tend to keep each other vigorous in the market place.

Remote Server ?

janhess wrote:Bit difficult using Unix commands on Windows.
I'll have a think about it.
Jan

Not at all. Get MKS Toolkit or CygWin or similar.

I believe - though I've never done it - that you start the installation process again and it detects that ProfileStage is already installed and goes into maintenance mode. Without either the software or the manuals this week I can't confirm that. Perhaps you can.

Control the FTP separately from DataStage, or from an Execute Command activity in a job sequence, or from a before-job subroutine. Use a Filter command in a Sequential File stage to execute your unzip utility; the Sequential File stage will read stdout from the filter command if one is specified.

Welcome aboard.

I don't believe it's possible. But you can always remove the executable from the export file afterwards.

The other possibility is some kind of arithmetic overflow, for example if DataStage were counting the number of bytes transmitted or something. Certainly not something we mere mortals could affect!

Are you perhaps running in a VMWARE instance? I've seen things like this happen when that is the case.

OK, the data come in in serial fashion. You immediately partition on the sort key (using Hash or Modulus as the partitioning algorithm, the latter only if the sort key is an integer sequence) - the Sort stage can then sort in parallel. Also in the Sort stage is a property that allows you to vary the...

The second, because you don't take the delay of "insert failed because row exists so do update".

The nice thing about job parameters is that they give you this flexibilty - you will not need different jobs for initial load unless there are some conditions (such as differently-formatted legacy records) about which you have chosen not to inform us when posing your question.

No experience with Informatica Grid, but there are quite a few sites happily running DataStage Enterprise Edition on a grid. The main thing you need is a dynamic configuration file - which IBM sells a service to create for you.

No, what I'm saying is that, in the importer, there is a field in which you tell DataStage where the 01 level item is.