DSXchange

Hi All,
DS 8.5 on windows.

I came across an odd situation where I have a transformer link performing an insert to oracle, has verry poor performance, several rows per second.
This happens if I use a DS macro such as : DSHostName as the derivation for a column.

Work arounds include:
1. using a stage variable to encapsulate the macro and putting the stage variable in the column derivation.
2. passing the desirved value as a job parameter.

In those cases the job works like a charm

Not sure I consider that a 'workaround' but rather proper usage.

Specifically for #1, put the macro in the Initial Value of the stage variable and then leave its derivation empty. It will only be evaluated once (the performance hit) when the job starts and then simply used for every row after that.