I am using the Magic ETL tool. I am trying to left join a DataSet with 4.5m records to a smaller table with ~1100 rows. After awhile, it crashes and I get the following error message:
"OnboardFlowExecution(10847) data flow execution id (ca085a327ae6417685896fb90f62e971) failed: MergeJoin: Duplicate key limit in left table exceeded! Limit: 10000"
How could I remedy this in order to successfully execute my join in the Magic ETL? Please advise. Thank you.
-Mark