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
Poor performance - DS Marco in column derivation with Oracle
Moderators: chulett, rschirm, roy
Poor performance - DS Marco in column derivation with Oracle
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers