000-349 · Question #27
What additional parameter is needed when using a database for an input, that is not used when using a database for output?
The correct answer is A. Query. When using a database as an input source, a Query parameter is required to specify which records to retrieve - a parameter not needed when writing to a database output.
Question
What additional parameter is needed when using a database for an input, that is not used when using a database for output?
Options
- AQuery
- BPassword
- Cmdq file name
- DDatabase Name
How the community answered
(52 responses)- A81% (42)
- B6% (3)
- C2% (1)
- D12% (6)
Why each option
When using a database as an input source, a Query parameter is required to specify which records to retrieve - a parameter not needed when writing to a database output.
A database input requires a Query parameter (typically referencing an MDQ file or SQL statement) to instruct the map on which rows and columns to read from the database. A database output only needs connection and target table information because it is writing data rather than selectively retrieving it. This asymmetry reflects the fundamental difference between read and write operations against a database.
A password is a connection credential required for both input and output database configurations, not exclusive to input.
The MDQ file name is associated with defining the query structure, but the core additional parameter concept is the query itself, not the file name specifically.
The database name is required for both input and output connections and is therefore not unique to the input use case.
Concept tested: Database input vs. output parameter differences in map editor
Source: https://www.ibm.com/docs/en/b2b-integrator/6.1?topic=cards-database-input-card-properties
Topics
Community Discussion
No community discussion yet for this question.