DataMigrator Flow is not loading all of the expected data into the target

Diagnostics

Product: DataMigrator

Release: 8206

Primary OS: Windows

Solution Date: 2020-12-08

Problem

A DataMigrator Flow is not loading all of the expected data into the target.

Solution

The DataMigrator Flow is using an Inner Join for the source files and missing segments were causing the entire row to be omitted from the result set.

To address this issue, either change the Inner Join to an Outer Join, or create a procedure that specifies: SET ALL=ON. Add that procedure to a Process Flow so that it executes prior to the Data Flow.

Information is published on an "as is" basis without a warranty of any kind. Information Builders, Inc. ("IBI") hereby represents that such information has not been subject to any formal testing or review by IBI. IBI assumes no responsibility for usage of such information, including the implementation of solutions associated therewith. The customer assumes responsibility for the results obtained from such information. IBI is not responsible for and shall not be held liable for the results obtained, including but not limited to any errors, delays or omissions. IBI disclaims any liability for the completeness or accuracy of such information.