DSXchange

Wrong. You can sum(column) and sum(dummy) in the same Aggregator using the same grouping. If your data are sorted by the grouping fields and you specify Group as the aggregation mode, then your job will be maximally performant.

sum(dummy) is the equivalent of COUNT if dummy=1

How have you specified the Null Field Value property for this date field?

Welcome aboard. Stripped of the DataStage-specific information what you're seeing here is a regular SOAP fault. Consult the documentation for the web service you're invoking to identify the known SOAP faults that it generates and their likely causes and remedies. Try invoking from a different utilit...

Doesn't seem inelegant to me. You could investigate the Split Vector stage.

I guess the other issue for a new site is the possibility of maintaining two skill sets rather than one, though it's fair to say that there's a good deal of overlap.

There is a useful introduction manual in the documentation set, or you can glean this information from the IBM Information Center for Information Server v8r5.

How is the secret key's location identified when using it outside of DataStage? You need to work that into the DataStage design too. For example it may accept an environment variable that contains the pathname of the key file.

Provided that identical hardware and identical versions of software are involved, deploying executables means that you do not require a compiler on the target environment.

The short answer is that Information Server uses a service oriented architecture where pretty much everything you do involves invoking a service, for example the login/security service, the metadata delivery service, and so on. These services are exposed by a dedicated instance of WebSphere Applicat...

Verify that the configured authentication information for the services associated with the Operations Console are all correct, in particular the passwords. Is there any additional information in the error messages?

saraswati wrote:Someone pls provide an alternative way to get it resolved.

Is there a problem with the advice that I gave?

A routine can be run by multiple processes at once. However, the sequence is only one process that executes the code on the Job Control tab in its job properties. You could have it (the sequence) start multiple sub-sequences each invoking the routine. Sub-sequences are forked as child processes of t...

You specified Null Field Value for CTSIFA as " " but the data contains "". I think this is at the heart of your problem. Try specifying Null Field Value as "" (and the data type as VarChar if necessary).

Vive la France!

Looks like your two repositories are out of sync. The SyncProject utility (part of ISA Lite) should solve this for you.