DSXchange

Provided your database can handle Cyrillic characters (irrespective of how they're encoded) the existing data warehouse should be OK. No need for translations unless non-Russian speakers need to view the data.

Welcome aboard.

Please use proper English on DSXchange; the word you wanted is "please", not "plz" (which isn't a word at all in English).

You can find your answer via Search. A good start point might be an exact search on Updaing SDKSequence (sic).

As far as adding days to a date is concerned, this is far easier than you imagine. Get the date into internal format and add the days. Whether you need to convert it back to external format depends on what you want to do with the new date subsequently.

There isn't. DataStage is driven by metadata, not vice versa.

Even RCP means all you're doing is EL, not ETL. If you're going to do transformation, you need to name the source column(s) explicitly.

And there are cheaper tools for doing EL than DataStage.

Use \n as the End character.

Even your documentation / training about executing DataStage in a grid environment should have differentiated these terms. They are only relevant when you are running under control of some kind of grid management software. Put simply, the head node is where control is exerted; the conductor process ...

Your timestamp string is in a collatable format. Declare it as Char (or VarChar) and get the max of that.

Using expressions based on the $Counter activity variable of the StartLoop activity.

A job to process one range of dates, invoked from a job sequence that loops through the list of fifty dates. The job sequence (inside the loop) can also look after the email.

Begin by suspecting database locks, and search for your exact symptom.

The alert message about fulfilling sort requirements is unrelated.

Also check whether scratch space is becoming filled.

Self-appointed guru apparently, and giving you a server job solution for a parallel job problem. Neither Transformer stage in parallel jobs allows for more than one input link. You could, however, do what he suggested using a Join stage. Or what Craig suggested, a technique known as a "key buck...

Don't bother. Director can do this for you and produce your report.

What is your "Lookup Failed" rule?

If partitioning is (Auto) you don't get to set the partitioning key at all.

(Auto) on inputs to a Join stage will use all the sort keys as the partitioning key and Hash as the partitioning algorithm.

I have added this path "C:\IBM\InformationServer\Server\PXEngine\bin", in the system variable of 'path' . In windows environmental variables. Still the dsjob command is not recognising! Does i need to change my path? Given that you originally marked your operating system type as UNIX, dar...