DSXchange

I disagree. Sequential File stage with cat as the filter command is way more efficient than a Link Collector stage.

Even easier, sort with a Sort stage and generate a Key Change column in that to detect change of value. Then do the stage variables thing in a downstream Transformer stage.

You could have this job

Maybe you could work on one of these projects

After-job subroutine ExecSH to mv the file to a new name that includes date. Search the forum for more details.

... or a Column Generator.

The View Data tool is "one size fits all" and rarely fits perfectly. Ignore its little idiosyncracies - it's only about getting "a bit of a look" at the data.

... or use the Version number field.

Even quicker, execute a query against DS_AUDIT (for example from the Administrator client command window).

cd to the project directory.

Disable operator combination to get a better idea (some idea) of which stage is throwing the errors.

Download ETLstats from Kim Duke's website - it does all that for you. Never re-invent the wheel unnecessarily.

Has someone deleted or changed the permissions on DS_AUDIT or D_DS_AUDIT in your project?

Do you see this problem in any other project?

This is the incorrect forum for your question. This forum is to discuss possible topics for a formal FAQ in that forum.

*Note: Topic Relocated - Content Editor*

Are you using WebSphere Transformation Extender (TX)? If not, please don't post in the TX forum.