Parameterization

You can parameterize the following properties when you create mappings:

•Source properties. Source type, source connection, query options in source, database name, table name, and advanced properties in the source.
•Target properties. Target type, target connection, target database name, target table name, and target advanced properties.
•Lookup properties. Lookup type, lookup connection, lookup advanced properties.

You can parameterize the following properties when you create mappings in advanced mode:

•Source properties. Source type, source connection, database name, and table name in the source.
•Target properties. Target type, target connection, target database name, and target table name.

Consider the following rules and guidelines for parameterization:

•You cannot use a parameter file to parameterize the database name.
•When you use a parameter file to parameterize the table name, specify only the table name in the parameter value. Do not specify the database name with the table name in the parameter value. For example, <databasename>.<tablename> or <databasename>/<tablename>.
•When you parameterize the source or target connection in a mapping and you do not specify the database name, ensure that you specify the database name in lowercase when you assign a default value for the parameter.
•When you parameterize the source filter condition or any expressions in a mapping, ensure that you specify the table name in lowercase when you add the source filter condition or the expression in the mapping task. Otherwise, the Secure Agent throws the following exception:

Invalid expression string for filter condition

•When you parameterize the source or lookup object, ensure that the column names in the source object and lookup object are not the same. Else, the mapping fails.