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.

how to optimize insert update delete?


 
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
02720825
Forum Member
Forum Member



Joined: 09 Sep 2019

Posts: 1



PostPosted: Mon Sep 09, 2019 3:48 am 
Post subject: how to optimize insert update delete?

Hello,

in my scenario, i want to insert data in target if source having new record,
update target table whenever source record is updated, and delete from target when record deleted from source. also i want to optimize this because we have 306 billion record which takes more than 4 hrs.

i used table comparison with map operation as normal-normal, insert-insert, update-update. delete-delete.
i have required same records which available in source. but in my scenario i have not getting desired output.

please guide
and
thanks in advanced.
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.0261 seconds using 18 queries. (SQL 0.0026 Parse 0.0008 Other 0.0227)
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