job logic

[kksr]

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 LC source column as 02
Output Format:
QTYNAME QTYVAL
GLTR 01
LTR 02
GLTR 03
LTR 04

Please help me for the above logic

_________________

[Sainath.Srinivasan]

You do not have funnel in server jobs.

But depending on whether the output is database or flatfile or any other media, you can change your design.

For example, if database, you can insert as separate streams.

Btw, what must happen if any of the 2 column value is 00 or blank ?

[chulett]

You do not have funnel in server jobs.

But you do have a Link Collector.

[Zafar]

Best option would be to separate it in the source query:
Like if source is a SQL database:

Select 'GLTR', GL
from table name

UNION

Select 'LTR', LC
from table name

Now in the xformer stage map the input and output columns accordingly..
Hope this logic works