- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Batch mode with Transactional Integrity
For Qlik Replicate with SAP IQ as a target, currently we have transactional mode and batch mode. Transactional mode will not work against SAP IQ as it does not handle OLTP workloads. Batch mode is better for SAP IQ but does not give transactional integrity
This does the following
Begin tran
Delete table a
Commit tran
Begin tran
Insert table a
Commit tran
Begin tran
Update table a
Commit tran
Begin tran
Delete table b
Commit tran
Begin tran
Insert table b
Commit tran
Begin tran
Update table b
Commit tran
Begin tran
Etc
Commit tran
We’d like to raise an ideation to create a new mode “Transactional Integrity Batch Mode”
This will do the following
Begin tran
Delete table a
Insert table a
Update table a
Delete table b
Insert table b
Update table b
Etc
Commit tran
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.