000-349 · Question #53
Refer to the Exhibit. Output card #2 creates a summary report that provides run time statistics. The Amount field in output card #2 is the total amount of all orders in the NewSysFile. Select the…
The correct answer is B. =TotalAmount Field:NewSysFile. In IBM Sterling map design, when a field already holds an accumulated total across all records, directly referencing it is more efficient than applying any aggregate function.
Question
Refer to the Exhibit. Output card #2 creates a summary report that provides run time statistics. The Amount field in output card #2 is the total amount of all orders in the NewSysFile. Select the most efficient map rule for the Amount field in output card #2
Options
- A=SUM(TotalAmount Field:NewSysFile)
- B=TotalAmount Field:NewSysFile
- C=ADD(ExtendedPrice Field:.:NewSysFile)
- D=ExtendedPriceField:.:NewSysFile * No_of_Records Field:NewSysFile
How the community answered
(47 responses)- A4% (2)
- B74% (35)
- C6% (3)
- D15% (7)
Why each option
In IBM Sterling map design, when a field already holds an accumulated total across all records, directly referencing it is more efficient than applying any aggregate function.
=SUM(TotalAmount Field:NewSysFile) would redundantly re-sum a field that already contains the total, adding unnecessary processing overhead when a direct reference suffices.
The TotalAmount field in NewSysFile already represents the pre-accumulated total for all orders in the file, so the rule =TotalAmount Field:NewSysFile directly maps that value without any additional computation, making it the most efficient choice. No summation or arithmetic is needed because the accumulation has already occurred upstream in the map logic.
=ADD(ExtendedPrice Field:.:NewSysFile) sums individual line-item extended prices rather than referencing the pre-calculated TotalAmount, making it less efficient and more error-prone.
Multiplying ExtendedPrice by No_of_Records assumes every order has an identical amount, which is not valid for a general total-of-all-orders calculation.
Concept tested: Efficient map rule selection for summary output fields
Source: https://www.ibm.com/docs/en/b2b-integrator/6.1.0?topic=rules-map-overview
Topics
Community Discussion
No community discussion yet for this question.