In this scenario, there is one input file (SOHeader), which contains 200,000 records. The records in SOHeader file are c

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

In this scenario, there is one input file (SOHeader), which contains 200,000 records. The records in SOHeader file are c

Post by answerhappygod »

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"?
In This Scenari 1
In This Scenari 1 (9.41 KiB) Viewed 81 times
A. LOOKUP()
B. CHOOSE()
C. EXTRACT()
D. SEARCHUP() E. SEARCHDOWN()
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top

This topic has 1 reply

You must be a registered member and logged in to view the replies in this topic.


Register Login
 
Post Reply

Return to “Archived Questions & Answers”