DSXchange

I detect some misunderstanding of how C (or C++) programming works. You don't "copy into a compiler". You use a compiler to convert your source code into something executable, and you use a linker to add references to any other libraries/objects that your code needs. To use such a routine ...

Let's begin with a question - how does the routine generate the data in the first place? There are a few ways to get data from a routine into a file, the most usual is to use OpenSeq, Seek, WriteSeq and CloseSeq statements. For a single line of data, though, it may be enough to assemble the line of ...

The assumption on which your question is predicated is false. It is not necessary to recompile after a job aborts.

It is sufficient to reset. This is a special run mode, to get things back to as they were (as far as is possible) as at the start of the aborted run.

Do learn how to Search DSXchange.

The answer to your question is already there.

As each new job is created it is allocated a unique number in the project. The name of the table that holds the mapping from job name to job number, as well as the job type, etc., is DS_JOBS.

Welcome aboard.

One answer is 0.5 (ignoring the x, but then there's no such version as 7.5x).

There is no single major difference.

You should Search DSXchange for the answer to your question - it has been answered, probably more than once, in the past.

Please post an exact error message. What are the data types of the columns in the target table - that is, the data types that are reported when you import the table definition? And what stage type are you using to effect the upsert?

A shared container must have at least one input or one output; otherwise how would you incorporate it into a job?

We can't deal with "not working". It's inexact. Please post the exact error message that you get.

Meanwhile consider creating a synonym for this column, where the synonym does not have any special characters in its name. Use the synonym in your job design.

You are 100% correct to use Hash partitioning algorithm on the same keys on both stream and reference inputs. It is totally risk free if done correctly. On a single machine, Entire on the reference input isn't much of an overhead because a single copy of the reference data set is put into shared mem...

I think that question is far enough from the original topic of this thread to warrant your creating a new thread for it.

Install DataStage server on a UNIX platforms.

DataStage jobs do not create native operating system executables; they create executables that run in a "virtual machine" called a DataStage engine.

ODI stands for "one day international", a form of the game of cricket. Doubtless you knew that. Based on second hand information, the Oracle offering will have you doing most of the work in sqlplus scripts, which are more difficult to produce and to maintain than the equivalent using graph...

An ETL project can not exist "in thin air" - it must exist towards some goal. In all cases there needs to be a business case established and, following from that, an analysis of what is required. This is typically the realm of someone with a title like "business analyst", often w...

Completely separate, on a separate file system for preference. I usually create a subdirectory called ControlFiles in the project directory on the server.