Hi All,
We’re trying to load up data in to a DB2 table using the auto correct load (allow merge) from a Data Transfer (using table) to target table. For the majority of the dataflows, it’s happily created a merge statement, however, for one it’s decided to do a cursor and row-by-row. It’s using the same datastores as used in the other tables and everything I can see is configured the same (at least for the DT to Target). As the table has potential to be 100K+ rows, it’s taking a very long time to complete (last run 17 hours)
Anyone hit this configuration and how did you get it to revert to a merge?
I’ve tried re-creating components, using other datastores (using same user), fiddled the various options all with no luck.
Any ideas?
Thanks in advance
Kryt0n (BOB member since 2010-10-14)