DSXchange

Spend some time learning about what the PATH environment variable does in the operating system. Since neither the parent directory of the dsjob command nor the current working directory is specified in your command search list (that is, PATH), you will continue to get the "not found" messa...

Failed lookups will return NULL from the reference input when the "lookup failed" rule is Continue. You can test for these nulls downstream of the Lookup stage(s) using a Filter or Transformer stage.

Reject link while reading is meaningless, provided the metadata match what's in the Oracle table. You get what there is.

IBM will sell you a service to do the conversion, and you have to agree that your jobs can be "offshored" (although, since you're in Bangalore, they may not go far). Internally IBM has some tools to help with this process but they are not releasing those tools, and still need to analyse wh...

Assuming your data are sorted appropriately use an Aggregator stage to specify "Last" of each group, grouped by order_id. THEN use a Folder stage.

This forum is really about tools in the IBM InfoSphere Information Server suite, not about data warehouse design. As Craig suggests, there are plenty of other sources of that information. Perhaps your interviewer might be able to suggest some.

Using a loop will be sequential. You need to design a separate sequence for each value of N (number of parallel iterations) and a sequence to determine N and select the correct one of these.

I am hired from time to time, particularly for new sites, to set up best practices (even a Centre of Excellence in some cases) and to mentor the new people. This (hiring an expert) is a more intelligent approach to my mind than expecting a novice to provide this guidance.

If you are new to DataStage, why are you tasked with putting together such a 'performance tips and coding standards document' !!?? Exactly my thoughts! Truly mind boggling. How can anyone new to any tool/product be expected to put together any kind of 'tips' or 'best practices' document? You need t...

It means that you are to add the name of an Orchestrate operator.

Search DSXchange if you need to know what an Orchestrate operator is.

Do it. Find out.

Yes.

The Multiple Job Compile tool has a check box to select only uncompiled jobs.

You can, alternately (if you have a UNIX-based ODBC driver for Excel), use ODBC to read from the worksheet. It is probably easier to script a mechanism for dumping the worksheet into CSV format (or similar), transfer that file to the UNIX machine, and have DataStage read the CSV file.

That really depends on what is meant by "reject" but, in most cases, explicit reject-handling output links from stages combined with post-job row count reconciliation ought to do most of what you require.