BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Getting cursor insert on Auto Correct Load


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
Kryt0n
Forum Member
Forum Member



Joined: 13 Oct 2010

Posts: 21



PostPosted: Tue Dec 03, 2019 2:51 pm 
Post subject: Getting cursor insert on Auto Correct Load

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
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0275 seconds using 17 queries. (SQL 0.0027 Parse 0.0008 Other 0.0240)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo