Guidelines for sources and targets in data integration tasks

• •Field names must contain 65 characters or less.
• •Field names must contain only alphanumeric or underscore characters. Spaces aren't allowed.
Note:
You can configure a mapping to allow special characters in field names. For more information, see Mappings.
• •Field names can't start with a number.
• •Each field name must be unique within each source and target object.
• •Data Integration truncates data if the scale or precision of a numeric target column is less than the scale or precision of the corresponding source column.

Rules and guidelines for flat file sources and targets

• •All date columns in a flat file source must have the same date format. Rows that have dates in a different format than the one specified in the synchronization task definition are written to the error rows file.
• •Each flat file target must contain all fields that will be populated by the synchronization task.
• •The synchronization task truncates a flat file target before writing target data to the file.
To avoid overwriting target data, you might use a post-session command to merge target data with a master target file in a different location.
• • The flat file cannot contain empty column names. If a file contains an empty column name, the following error appears:
Invalid header line: Empty column name found.
• •Do not map binary fields when you use a flat file source or target in a synchronization task.
• • Column names in a flat file must contain printable tab or ASCII characters (ASCII code 32-126). If the file contains a character that is not valid, the following error appears:
Invalid header line: Non-printable character found. The file might be binary or might have invalid characters in the header line.
• •You can use a tab, space, or any printable special character as a delimiter. The delimiter can have a maximum of 10 characters. The delimiter must be different from the escape character and text qualifier.
• •For flat file sources and targets with multibyte data on Linux, the default locale must be UTF-8.

Rules and guidelines for database sources and targets

• •You can use database tables as targets. You can use database tables, aliases, and views as sources.
• •Relational targets must meet the minimum system requirements.
• •The database user account for each database target connection must have DELETE, INSERT, SELECT, and UPDATE privileges.