Hello all,
We are trying to dynamically concatenate columns(Column names can be parameterised) and so is the output column in an RCP Enabled job.
I must use RCP. Thats the only transformation i need to do.
Any inputs are greatly appreciated..
Thanks
Koti
RCP Job - Dynamic Concatenation
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Any transformation needs to name the input column(s). That's an absolute rule!
You can't use a Modify stage here, since concatenation is not available as a Modify stage operator/function.
You can't use a Modify stage here, since concatenation is not available as a Modify stage operator/function.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
While this post did not clearly describe your motive, based on the previous post, I am assuming that you are trying to concatenate keys to support CDC.
As Ray has stated, named columns is a must for concatenation.
A workaround for this can be designed by using Column Export stage.
1. Define Schema files (one per table) listing the columns that need to be concatenated.
2. Parameterize schema-filename and pass it to a generic job described below.
3. Create job using Column Export stage to concatenate columns, passing schema-filename in properties.
As Ray has stated, named columns is a must for concatenation.
A workaround for this can be designed by using Column Export stage.
1. Define Schema files (one per table) listing the columns that need to be concatenated.
2. Parameterize schema-filename and pass it to a generic job described below.
3. Create job using Column Export stage to concatenate columns, passing schema-filename in properties.
Since your column names are parameterized, you can use a MODIFY stage to "name" your parameterized columns, i.e.
Then do your concatentation to a newly created column a in a subsequent Transform stage using your 2 columns.
If you need those 2 columns in the output, then you need another modify downstream of the transform that does
Code: Select all
TEMPCOLUMN1=#ParameterColumnName1#
TEMPCOLUMN2=#ParameterColumnName2#
If you need those 2 columns in the output, then you need another modify downstream of the transform that does
Code: Select all
ParameterColumnName1#=TEMPCOLUMN1#
ParameterColumnName2#=TEMPCOLUMN2#
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>