IBM
000-349 · Question #41
000-349 Question #41: Real Exam Question with Answer & Explanation
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
Explanation
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.
Common mistakes.
- A. 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.
- C. UNIQUE eliminates duplicate records from a data set and cannot be used to filter records by type field value.
- D. 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
Reference. https://www.ibm.com/docs/en/b2b-integrator/6.1.2?topic=functions-extract
Community Discussion
No community discussion yet for this question.