000-349 Question #45: Real Exam Question with Answer & Explanation

The correct answer is A. INDEX and RUN. Splitting a multi-record input file into individually named output files in a WTX/Sterling map requires INDEX to retrieve the current record number for use in the filename, and RUN to execute a functional map that produces each separate output file per record.

Question

An application developer needs to split a file consisting of 10 records into 10 output files each with one record. The file name of the output files must contain the record number from the input file. What two functions can be used in this map to achieve this task?

Options

AINDEX and RUN
BCHOOSE and PUT
CINDEX and SETFILENAME
DCOUNT and CREATEFILE

Explanation

Splitting a multi-record input file into individually named output files in a WTX/Sterling map requires INDEX to retrieve the current record number for use in the filename, and RUN to execute a functional map that produces each separate output file per record.

Common mistakes.

B. CHOOSE selects a value based on a conditional test and PUT writes data to an output location, but neither provides the per-record occurrence number needed to dynamically name 10 separate output files.
C. SETFILENAME is not a valid standard function in the WTX/Sterling map function library, so pairing it with INDEX cannot produce the required output even though INDEX alone correctly supplies the record number.
D. COUNT returns the total number of occurrences of an object and CREATEFILE is not a recognized WTX map function, so this pair cannot perform the iterative file-splitting and dynamic naming required.

Concept tested. INDEX and RUN functions for iterative file splitting

Reference. https://www.ibm.com/docs/en/b2b-integrator/6.1?topic=functions-index

Community Discussion

No community discussion yet for this question.

Full 000-349 Practice