000-349 · Question #41
A map is being developed to process input data that contains invoices and purchase orders. The first 5 records of the data is provided below. 177735,PO,Acme Products,1000.23,10102008<NL>…
The correct answer is B. EXTRACT. In a functional map, the EXTRACT function is used to filter and process only records that match a specific condition, such as identifying purchase orders by their type field.
Question
A map is being developed to process input data that contains invoices and purchase orders. The first 5 records of the data is provided below. 177735,PO,Acme Products,1000.23,10102008<NL> 334,INV,Acme Products,373.56,10112008<NL> 385,INV,Some Co.,775.75,09282008<NL> A336,PO,CompanyB,344.65,10092008<NL> 394,INV,MyCo,200.65,11112008<NL> The characters INV in the second field identify the record as an invoice. The characters PO from the second field identify the record as a purchase order. The application requires only processing purchase orders. Which function can be used in the functional map call to process only the purchase orders.
Options
- ACHOOSE
- BEXTRACT
- CUNIQUE
- DLOOKUP
How the community answered
(28 responses)- A7% (2)
- B79% (22)
- C11% (3)
- D4% (1)
Why each option
In a functional map, the EXTRACT function is used to filter and process only records that match a specific condition, such as identifying purchase orders by their type field.
CHOOSE selects a value from a set of alternatives based on a positional or conditional index and is not used to filter records in a functional map call.
EXTRACT is the function used in a functional map call to select a subset of records from an input data stream based on a conditional expression. By specifying the condition that the second field equals 'PO', EXTRACT ensures the functional map processes only purchase order records and skips all invoice records.
UNIQUE eliminates duplicate records from a data set and cannot be used to filter records by type field value.
LOOKUP retrieves matching data from a reference file using a key and is not designed to filter or subset records during functional map processing.
Concept tested: EXTRACT function for filtering records in functional maps
Source: https://www.ibm.com/docs/en/b2b-integrator/6.1.2?topic=functions-extract
Topics
Community Discussion
No community discussion yet for this question.