A delimiter separates records in the source file. If a message contains multiple records separated by a delimiter,
breaks the message down at each delimiter boundary to get individual records.
removes the delimiter from each record and passes the records to the transformation one record at a time. The transformation transforms a record and, based on whether or not a transformation follows it in the chain, forwards the record to either the next transformation or the target services. After forwarding a record, the transformation accepts the next record in the message.
If you want to replace the delimiter that
removes, specify a delimiter when you create a transformation. The number and choice of delimiters that you can use vary across the built-in transformations. In some transformations, you can insert custom delimiters while in other transformations, you cannot use custom delimiters and the number of built-in delimiters is restricted.
If you add multiple transformations on a connection, and you append a delimiter in more than one transformation, the data that the target data store receives contains all those delimiters in sequence. Therefore, either append a delimiter in only the final transformation or, if you append a delimiter in an intermediate transformation, do not append delimiters in subsequent transformations in the chain.