In this scenario, there is one input file (SOHeader), which contains 200,000 records. The records in SOHeader file are c
Posted: Fri Aug 26, 2022 9:59 am
In this scenario, there is one input file (SOHeader), which contains 200,000 records. The records in SOHeader file are comprised of three fields: SONumber, SOOrdType, andShipToCustomer. The file is sorted by SOOrdType (ascending order).Here is a snapshot of a few records in the file:What is the MOST EFFICIENT function to use to find the first record whereShipToCustomer = "John"?
A. LOOKUP()
B. CHOOSE()
C. EXTRACT()
D. SEARCHUP() E. SEARCHDOWN()
- In This Scenari 1 (9.41 KiB) Viewed 83 times
B. CHOOSE()
C. EXTRACT()
D. SEARCHUP() E. SEARCHDOWN()