Hi All,
I am designing one server job..
I have 2 columns from the source ( GL and LCL) which need to be loaded into target
Source Fields
GL LC
01 02
03 04
from the GL source filed I have load the data into target fields QTYNAME QTYVAL
For QTYNAME, I have to hard the value as GLTR and for QTYVAL, I have display from GL source column as 01
From the LC filed I have load the data into target fields QTYNAME QTYVAL
For QTYNAME, I have to hard the value as LTR and for QTYVAL, I have display from GL source column as 02
Output Format:
QTYNAME QTYVAL
GLTR 01
LTR 02
GLTR 03
LTR 04
Please help me for the above logic
DS Job design logic
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Two outputs from Transformer stage, one for GL and one for LCL. Bring them together subsequently with an Aggregator stage.
I think you can figure out the column derivations.
Add a "key" column (derived as @INROWNUM) that you can use to re-unite the original rows.
I think you can figure out the column derivations.
Add a "key" column (derived as @INROWNUM) that you can use to re-unite the original rows.
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.