Many customers maintain common error tables to log errors encountered when processing data. Often the errors are tracked at column level and when a particular row of data has issues in multiple columns, then multiple rows have to be inserted into the error table. This can be achieved using IDMC transformations (CDQ rule specification/Expression, Union, Joiner). Scenario: Consider that when you are processing input data, if there are NULL values in the Input columns, then, they have to be populated as errors in a separate flat file or table. For example, if there are NULL values for Email and Phone_Number for a particular customer, then the output row to the error table should contain the Customer Name and an error message that says Invalid Email or Invalid Phone_Number. Source rows:

Custom Error Table entries :