nerdexam
IBM

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.

Development

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)
  • A
    4% (2)
  • B
    74% (35)
  • C
    6% (3)
  • D
    15% (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.

A=SUM(TotalAmount Field:NewSysFile)

=SUM(TotalAmount Field:NewSysFile) would redundantly re-sum a field that already contains the total, adding unnecessary processing overhead when a direct reference suffices.

B=TotalAmount Field:NewSysFileCorrect

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.

C=ADD(ExtendedPrice Field:.:NewSysFile)

=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.

D=ExtendedPriceField:.:NewSysFile * No_of_Records Field:NewSysFile

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

#SUM function#multi-card maps#map rule efficiency#aggregation

Community Discussion

No community discussion yet for this question.

Full 000-349 Practice