When building a map, the following build error message is displayed: M111 ERROR:
LegacyToNew Output: NewOrderRecord:NewSysFile Argument #2 for map
F_MakeNewOrderRecord does not match type of input card #2. What action should be taken to
resolve the build error?

What is the first thing that must be done in order to create a map to use a database as a source in
an input card?

A database table is depicted here:

Which of the following functions COULD be used to return only the text string that is found in the
Part_Description column of the database?

A developer is loading the following records into a database:

The database record has four fields; each field will contain one letter from the file above. The
update key in the .MDQ file is set to the first field of the table. The UPDATE flag is not set on the
card but OnFailure->Rollback is set.the table. The UPDATE flag is not set on the card but
OnFailure->Rollback is set. Using the adapter trace shown below:

How many record(s) will be inserted into the database?

When using WebSphere Transformation Extender to integrate with an e-mail provider, which two

of the following are TRUE statements?

What additional parameter is needed when using a database for an input, that is not used when
using a database for output?

What is the BEST method to create a backup of bad input data?

What is the method for indicating a reference to a specific occurrence of an input object in a map

rule?

The following map rule returns the incorrect results; however, the map rule does return the
expected results when each LOOKUP is run independently.
=IF(PRESENT(Name:.:AddressFile), LOOKUP(Record:input,Field1 Field:Record:input=”aa”),
LOOKUP(Record:input,Field1 Field:Record:input=”cc”))
Why does the rule return the INCORRECT results?

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, and ShipToCustomer.
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 where ShipToCustomer = “John”?