Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
-
raam_datastage
- Participant
- Posts: 3
- Joined: Tue Apr 08, 2008 4:05 am
- Location: Chennai
Post
by raam_datastage »
I need to concatenate two string fields.what is the equivalent of : in parallel edition?.Is concatenation possible in modify stage?
Yagnaraman.M
-
devidotcom
- Participant
- Posts: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad
Post
by devidotcom »
As far as I know concatentation is not possible in modify stage
-
raam_datastage
- Participant
- Posts: 3
- Joined: Tue Apr 08, 2008 4:05 am
- Location: Chennai
Post
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?
Yagnaraman.M
-
raam_datastage
- Participant
- Posts: 3
- Joined: Tue Apr 08, 2008 4:05 am
- Location: Chennai
Post
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?
Yagnaraman.M
-
devidotcom
- Participant
- Posts: 247
- Joined: Thu Apr 27, 2006 6:38 am
- Location: Hyderabad
Post
by devidotcom »
Yes in transformer we can do it but without any function just use :
String1:String2
-
BugFree
- Participant
- Posts: 82
- Joined: Wed Dec 13, 2006 6:02 am
Post
by BugFree »
Concatenate is same ":" in parallel as well. You can do it in a transformer stage. Not sure about Modify though.
Ping me if I am wrong...
-
krisna
- Participant
- Posts: 77
- Joined: Tue Apr 08, 2008 11:33 pm
Post
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.
-
krisna
- Participant
- Posts: 77
- Joined: Tue Apr 08, 2008 11:33 pm
Post
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.