Discussion

1623
Views
DilipKMondal Member since 2012 14 posts
Cognizant Technology Solutions
Posted: 5 years ago
Last activity: 5 years 8 months ago
Closed

Troubleshooting deferred write operations

(1) debugging

As a debugging aid, the standard HTML rule @baseclass.DeferredOps interrogates system internals and presents an ordered list of deferred (uncommitted) database operations for the current Thread. In a step immediately before a Commit method, your activity can display this HTML rule using the Show-Page method, to see what will be committed.

 

(2)  Oracle DB Level

Two Options:

    Initially immediate(default) - constraint validated at statement level
    Initially deferred - constraint validated at commit level

 

For deferred write operations, please use the 2nd option foreign key(Child Key)

 

ALTER TABLE <<Table>> ADD CONSTRAINT <<FK_Name>>

    FOREIGN KEY ("Column_Name_PK") REFERENCES <<Schema_Name.Parent_Table>> ("Column_Name_PK") ENABLE
    INITIALLY DEFERRED DEFERRABLE;

 

 

Data Integration
Moderation Team has archived post
Share this page LinkedIn