Data Transformation Engine Map Designer Reference Guide

Chapter 5 - Card Settings SourceRule Input Card Settings
Map Designer Reference Guide
86
Note The maximum size of a file that a map can process in integral mode is 2 GB. In
burst mode, the maximum size is much larger, but can only be 2 GB in one burst.
Source > FilePath
When Source = File, the FilePath setting specifies the name and path of the
input data file. Enter the filename or click
(browse) to display the Select Data
File dialog box in which you can navigate your file system to select the input file.
Source > Command
When Source = various resource adapters, the Command card setting provides
the adapter-specific commands to connect to the data source and retrieve the
input data. For example, if the input data is coming from a file, the Command
specifies the name of the input file. If the input data is coming from a database,
the Command might include the database name, user ID, password, and so on.
The command syntax for the source and target adapter commands is detailed in
the adapter-specific documentation. The maximum length of a source or target
adapter command is 260 bytes. Limitations to the maximum adapter command
length may apply to some adapters.
DatabaseQueryFile
When Source = Database, the DatabaseQueryFile settings are used to specify
the database specific settings: the name of the desired database/query file, the
database name, and the query.
DatabaseQueryFile > Database
Specify the database that contains the desired query definition.
DatabaseQueryFile > Query
Specify the name of the desired query.
DatabaseQueryFile > File
Specify the database/query file (.mdq) that contains the desired source database
and query definition.