Hi All,
Is it good practice to do transformation into one variable
e.g trim(ereplace(DSLINK.col1," ","-")
or do
trim(DSLINK.col1)=variable1
ereplace(variable1," ","-") =variable2
how does the process work in both the cases
thanks
kris
processing
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 20
- Joined: Mon Dec 05, 2005 8:07 pm
- Contact:
processing
KRIS
Ignoring that your examples give different results (trim and ereplace vs. ereplace and trim), it's perfectly fine to nest functions, just keep your logic legible. Consider using stage variables when the same derivation of a value is repeated for many columns, or you need to simply a derivation/constraint.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
The first one performs only one variable assignment, the second one needs to do 2; so the first will be more efficient. As Ken has stated, they will in their current form give different results.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Participant
- Posts: 20
- Joined: Mon Dec 05, 2005 8:07 pm
- Contact:
Thanks All,
Assuming both the results give the same output .
iam sorry for posting wrong way.
iam just intrested in knowing how the internal process works is their any kind of documentation links or .pdf where i can know how the datastage processes the incomming data with the stages.
thanks once again for replies..
kris
Assuming both the results give the same output .
iam sorry for posting wrong way.
iam just intrested in knowing how the internal process works is their any kind of documentation links or .pdf where i can know how the datastage processes the incomming data with the stages.
thanks once again for replies..
kris
KRIS