Change data from source file to target?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 96
- Joined: Fri Aug 20, 2010 8:51 am
I agree with you to write in column derivation instead of Stage variable. I was habituated to write stage variables for new derivations.chulett wrote:Copy/paste characterset issue. Replace the "-" with one typed on your keyboard. And there's no need for a stage variable to do this. ...
Please suggest any performance implications is there using stage variables.
Thanks.
Cheers
Ravi K
Ravi K
Any 'performance implications' should be for the positive if they are leveraged properly. There isn't in this case, either way, it just doesn't show a good understanding of how to leverage them. Typical use would be for derivations that you need to leverage multiple times in the stage - derive it once in the stage variable, reference it multiple times.
There are other uses, of course, for example self-documenting a complex derivation either by judicious naming of stage variables and/or breaking the derivation up into bite-sized (and well named) chunks that make more sense when put back together.
And of course, a poorly written derivation - be it in a stage variable or not - can certainly have performance implications. And not of the good kind.![Wink :wink:](./images/smilies/icon_wink.gif)
There are other uses, of course, for example self-documenting a complex derivation either by judicious naming of stage variables and/or breaking the derivation up into bite-sized (and well named) chunks that make more sense when put back together.
And of course, a poorly written derivation - be it in a stage variable or not - can certainly have performance implications. And not of the good kind.
![Wink :wink:](./images/smilies/icon_wink.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers