DSXchange

Within Metadata Workbench you could create an Extended Data Source and/or an Extension Mapping Document, which would treat Informatica as a "black box". Third party software, such as MetaDex from CompactBI, can convert the Informatica maps, etc., into the common metadata model used in MWB ...

There isn't anything really reliable. You might like to investigate SELECT CLASS, INSTANCE, PREVDTD, PREVDELETOR FROM DS_AUDIT WHERE PREVDTD IS NOT NULL AND PREVDTD > ''; This query can be executed from the Administrator client's Command window. However the deletor will be the value of the Engine cr...

I'd forgotten the "R" option for Trim(). It's not an option I use very often.

May we know why you think you need this list?

There isn't.
Do you have backup/export?

You can use the Performance Analysis tool in DataStage Designer for completed jobs. To use this tool, collection of performance data must have been enabled prior to running the job. There is no command within DataStage that provides details about running processes; if you have version 8.7 or later t...

If there are no space characters in your data (as per your example) you could convert the pipe characters to space characters, use a simple Trim() function (only one argument), then convert the space characters back to pipe characters. Convert(" ", "|", Trim(Convert("|"...

... or are you looking for a server that you can buy/hire?

Yay! Keep up the good work. And thanks from everyone who's benefited from ETLstats.

For a newbie four routine activities will give you four discrete return values. Diligent naming will make it clear which is which.

Returning multiple results via one routine is not what I'd put into the newbie capability set.

My ₤0.02 worth.

Download ETLstats (free) from Kim Duke's website - you will find that this particular wheel has already been invented.

Though you could deconstruct the container, do your debugging, then reinstate the container.

Four routine activities.

Hi Lance!

What Andy said.

If one is Windows don't overlook WinSCP.