DSXchange

It's not an editable dropdown - that is, there is no way (for example) to load a parameter into this field. The generated Job Control code is read-only in the sequence, so you can't change it there either. The only possibility is to copy the Job Control code and parameters from the sequence into a s...

Run all the reject links into a Funnel stage and its output to the Sequential File stage.

Two WaitForFile activities with OK triggers feeding into an "All" sequencer.

India2000 wrote:oracle connector doesn't allow me use sub query.

I find that very difficult to believe. It may be that the SQL Builder won't easily let you build a sub-query, but you can certainly create your own user-defined SQL, or even edit the built SQL, so that it incorporates a sub-query.

Now find somebody who can explain to you what those numbers mean. For example, the pair 41 (in hexadecimal, equates to 65 in decimal) represents the ASCII code for the character 'A'. Some non-printing characters have codes in the range 00 through 1F.

Basically, ensure that the metadata in your job design match absolutely those in Netezza. The easiest way to ensure this is to use table definitions imported from Netezza and never to edit them in the job designs.

Set up a reject link from the Transformer stage and capture the output link variables SQLSTATE, DBMSCODE and DBMSERROR (I think that's what they are called). They may reveal more detailed information than you are getting in the log file. Add @INROWNUM to the reject link so you can be sure which row ...

There is no table called RT_LOG. Each job has its own log, in a table named according to the convention RT_LOGnnn, where nnn is the unique job number allotted to the job and recorded in DS_JOBS table.

And do you mean on "UNIX in the mainframe environment" (for example USS or zLinux), or do you mean that DataStage is running on a separate UNIX server and you want to initiate jobs from the mainframe?

Probably not. How large are these records? Are you using Information Analyzer? Are you using DataStage Operations Console? Are you using QualityStage? Each of these requires database space on the Engine tier. As noted earlier, allow 4-5 times the volume of data to be profiled for IADB. Allow approxi...

Information Analyzer IS a tool for business analysts. To do everything that table profiling and rules profiling do you would have to write (and verify) very many SQL statements. The ability to clone many rules of one rule definition, the ability to combine rules into rule sets and the ability to ass...

Just for installation, or are you scoping run-time as well? The Planning, Installation and Configuration Guide on-line has good utilities for estimating installation disk space. Additional temporary space that can be reclaimed after installation is also needed. Projects don't need a whole lot. Data ...

Is the "directory on the other server" visible from (mounted on) the current server? That is, is the file for which you have to wait accessible via a regular or UNC pathname? If so, you can happily use the WaitForFile activity. If not, use a third-party enterprise scheduler with file detec...

All COMMENT sections can be safely ignored.

The command line export documents sections in which no instances were found to be exported; the GUI export does not - instead it reports to the screen how many read-only objects were excluded. The GUI is silent on empty categories.

The Pivot Enterprise stage (PXPivot) can perform both horizontal and vertical pivots and, as its name suggests, inherently carries the capability to execute in parallel. The older Pivot stage can only perform horizontal pivots and typically executes in sequential mode. It mirrors functionality of th...