BuildOp Stage
Posted: Sun Oct 19, 2008 8:39 am
Hi,
I have a simple BuildOp Stage that multiply two columns. This job execute fine but the output is not correct. In Sequential File there are three columns, the Amount is correct, but the another columns receive "0". These columns must pass without changes. I don't understand where is the error. Somebody can help me?
Row Generator ---> BuildOp Stage ---> Sequential File
Input
========
Qty
Price
Tax_Rate
Output
==========
Amount
Qty
Tax_Rate
Configurations:
BuildOp - Properties
=================
Exchange
BuildOp - Build
=================
Input: InRec - Auto Read: True - Table name: Saved\tmp\input - RCP: False
Output: OutRec - Auto Write: True - Table name: Saved\tmp\output - RCP: False
BuildOp - Logic in Per-Record
======================
Amount = InRec.Qty * InRec.Tax_Rate;
Amount = Amount * Exchange;
Thank you in advance
Luciana
I have a simple BuildOp Stage that multiply two columns. This job execute fine but the output is not correct. In Sequential File there are three columns, the Amount is correct, but the another columns receive "0". These columns must pass without changes. I don't understand where is the error. Somebody can help me?
Row Generator ---> BuildOp Stage ---> Sequential File
Input
========
Qty
Price
Tax_Rate
Output
==========
Amount
Qty
Tax_Rate
Configurations:
BuildOp - Properties
=================
Exchange
BuildOp - Build
=================
Input: InRec - Auto Read: True - Table name: Saved\tmp\input - RCP: False
Output: OutRec - Auto Write: True - Table name: Saved\tmp\output - RCP: False
BuildOp - Logic in Per-Record
======================
Amount = InRec.Qty * InRec.Tax_Rate;
Amount = Amount * Exchange;
Thank you in advance
Luciana