DSXchange

Set your Lookup Failed rule to Continue. Columns from the reference input will be NULL if the lookup fails. Detect this condition in a downstream Filter or Transformer stage. But why bother? Just reverse the sense of the "normal" and "reject" output links, and annotate your diagram to alert future d...

I should have aid identical key partitioning. This implies either Hash or Modulus as the partitioning algorithm.

What precisely do you mean by "first" and "last" in this context? The order in which rows are stored in database tables is under control of the database engine, not of the user, and therefore the terms "first" and "last" don't really have any meaning.

There is no such thing as a log file - each job log in DataStage is a separate table in the Repository database. The name of the table is RT_LOG followed by the job number. The job number is mapped to the job name in the DS_JOBS table.

So we're back to what do you mean by "not working"?

0x80 is the DataStage internal representation of NULL by default, so you may also want to look at the uvconfig file and choose a different internal representation of NULL if you really do have this character in your data.

Please post the exact SQL as displayed in your Oracle stage. Is this generated SQL or user-defined SQL?

Define "performance" in an ETL context.

Search is your friend.

Search is your friend.

Several examples, indeed. What does it mean that a record is "processed successfully"? (That is, what business rules are being validated?) Under what - presumably different - scenarios does a warning or an error get generated? The typical answer will be to record the test results in stage variables,...

An inline sort is where you specify sorting on the Partitioning tab of a stage's input link. An external sort is, presumably, where you use an explicit Sort stage. The latter gives greater flexibility, including controlling memory allocated to sorting, generation of key change indicators, and perfor...

The version 8.1 Pivot stage handles both horizontal and vertical pivots. My advice to use the Pivot stage was because your requirement not to use it is bizarre - always use the correct tool for the job. You can do everything you want in a Transformer stage, optionally preceded by a Sort stage genera...

Warning - Technical Content The reference input to a Lookup stage for a normal (not sparse) lookup causes a composite operator to be generated to perform two tasks, for which the operator names are LUT_CreateOp and LUT_ProcessOp. LUT_ProcessOp loads the virtual data set associated with the referenc...