DSXchange

The main point - which you don't show that you understand - is that for sorting to work properly in parallel the partitioning must ensure that each key value occurs only on one partition.

That's still database-specific.

Open Director, and uncheck Show Categories in the View menu. Then click on the heading of the Status column. Jobs will be sorted by status; Aborted will be at the top. To automate this process you will need to create a routine that iterates through all the jobs and selects those with the particular ...

All that's working. But when you create a timestamp, you don't want the AM/PM designator. Your derivation for Create_Date is correct, unless there's a newline in it. It must be on a single line. For example (for an ISO 8601 timestamp): Oconv(Iconv(svTimestampDate, "DMDY"), &quo...

Check that you have write access to every folder (including the root folder) in the pathname, and that every folder named in the pathname actually exists. Finally, check that the final entry in the pathname is the name of a folder.

A 286 chip or a Pentium IV class chip? Single core or dual core? Single CPU or multiple CPU? 640KB of memory (which Bill Gates once asserted should be all you ever need) or more? And so on. Your question is moot without specifying a particular hardware configuration.

Use stage variables to detect when last_name and first_name change. Use those to trigger updates to the "change has occurred" column (which you have referred to as a "column index").

How about three Execute Command activities in a job sequence, with NO LINKS between them?

If the date really is coming in internal integer format (how did you verify this fact?), then you need to apply a conversion function. Use Oconv() if it's DataStage internal format, or one of the SDK functions if it's based on a different base date (for example 1970 or 1900).

Which answer did you give?

Review the properties of the ORAOCIBL stage carefully. Look for a property with "automatic" in its name.

You are all very cruel!

Rahul is a new member of our community. Even if it is an interview question, it should have been handled with more grace, because of that very fact.

Shame upon you all!

When a VarChar is stored within osh it carries its length as a prefixed binary number, the size of which is specified by "prefix". A two-byte unsigned integer (uint16 or unsigned SmallInt) can address a string whose length is up to 2^16 characters. Longer strings require larger prefixes. {prefix=4} ...

No, it's enough to have two DataStage clients installed. However, they must be installed in different locations on the client machines, and differentiable in program groups.