Page 1 of 1
Concatenation function to be used in transformer?
Posted: Mon May 05, 2008 11:27 pm
by raam_datastage
I need to concatenate two string fields.what is the equivalent of : in parallel edition?.Is concatenation possible in modify stage?
Posted: Mon May 05, 2008 11:31 pm
by devidotcom
As far as I know concatentation is not possible in modify stage
Posted: Mon May 05, 2008 11:32 pm
by raam_datastage
Column export stage is one way to do this.But are there any concatenation function available which can be used in transformer?
Posted: Mon May 05, 2008 11:34 pm
by raam_datastage
Column export stage is one way to do this.But are there any concatenation function available which can be used in transformer?
Posted: Mon May 05, 2008 11:36 pm
by devidotcom
Yes in transformer we can do it but without any function just use :
String1:String2
Posted: Mon May 05, 2008 11:38 pm
by BugFree
Concatenate is same ":" in parallel as well. You can do it in a transformer stage. Not sure about Modify though.
Posted: Tue May 06, 2008 1:23 am
by krisna
In transformer we can use ":" for concatenating two strings.
The modify stage alters the record schema of its input data set. The modified data set is then output.
I think modify stage cannot be used for concatenating.
Posted: Tue May 06, 2008 1:24 am
by krisna
In transformer we can use ":" for concatenating two strings.
The modify stage alters the record schema of its input data set. The modified data set is then output.
I think modify stage cannot be used for concatenating.