Ask the Expert

Load data from a Transactional ODS object into other data targets

How do we update or load the data from a Transactional ODS object into other data targets?

    Requires Free Membership to View

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.

This was first published in March 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: