How do we update or load the data from a Transactional ODS object into other data targets?
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
In order to transfer data from a transactional ODS object into further data targets, first create update rules from ODS object to the datatarget you want to update. During the update rule creation, select the transactional ODS object as the infosource. For the transactional ODS objects "Update Data in Data Targets" option is not available in the context menu of the ODS object, so you have to manually create infopackage to transfer data.
Go to the infosources tab in the administrator workbench and create infopackage for the system generated export datasource (technical name is 8<technical name of the ODS>). Then you can just execute the infopackage to load data into subsequent data targets, but please keep in mind only full upload is possible (no delta upload) with transactional ODS objects.
Related Q&A from Nurullah Battal
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.