000-349 · Question #25
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? Create:
The correct answer is A. an MDQ file. Before mapping a database as a source in an input card, an MDQ (Map Data Query) file must first be created to define the database query structure.
Question
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? Create:
Options
- Aan MDQ file.
- Ba database query.
- Ca type tree to match the database table.
- Da functional map using the name and location of the database.
How the community answered
(49 responses)- A80% (39)
- B4% (2)
- C12% (6)
- D4% (2)
Why each option
Before mapping a database as a source in an input card, an MDQ (Map Data Query) file must first be created to define the database query structure.
An MDQ file defines the query used to retrieve data from the database and must exist before the map can reference the database as an input source. The Map Editor requires this file to understand the structure and retrieval logic of the database input. Without it, the input card cannot be configured to use the database.
A database query is defined within the MDQ file itself, so creating a standalone query is not the required first step.
A type tree is built to match the data structure, but it cannot be created or linked before the MDQ file exists to describe the source.
A functional map referencing the database location cannot be created until the MDQ file is in place to support the input card configuration.
Concept tested: MDQ file requirement for database input cards
Source: https://www.ibm.com/docs/en/b2b-integrator/6.1?topic=maps-creating-map-data-query-file
Topics
Community Discussion
No community discussion yet for this question.