What sequence of steps do you follow to achieve this?

You must modify the order in which data stores are being journalized in a model. What sequence of steps do you follow to achieve this? (Choose the best answer.)

You must modify the order in which data stores are being journalized in a model. What sequence of steps do you follow to achieve this? (Choose the best answer.)

A.
Open the model, go to the Journalizing tab, and modify the order there.

B.
Right-click Datastore, select Changed Data Capture, and then select Order.

C.
Open the model, go to the Journalized tables tab, and modify the order there.

D.
Open the data stores, go to the Journalizing tab, and modify the order there.

Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/data_capture.htm#ODIDG271)



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Amira

Amira

C

Set the datastores order (consistent set journalizing only):

You only need to arrange the datastores in order when using consistent set journalizing. You should arrange the datastores in the consistent set in an order which preserves referential integrity when using their changed data. For example, if an ORDER table has references imported from an ORDER_LINE datastore (i.e. ORDER_LINE has a foreign key constraint that references ORDER), and both are added to the CDC, the ORDER datastore should come before ORDER_LINE. If the PRODUCT datastore has references imported from both ORDER and ORDER_LINE (i.e. both ORDER and ORDER_LINE have foreign key constraints to the PRODUCT table), its order should be lower still.

To set the datastores order:

In the Models tree in the Designer Navigator, select the model journalized in consistent set mode.

1-Double-click this model to edit it.
2-Go to the Journalized Tables tab.

If the datastores are not currently in any particular order, click the Reorganize button. This feature suggests an order for the journalized datastores based on the foreign keys defined in the model. Review the order suggested and edit the datastores order if needed.

3-Select a datastore from the list, then use the Up and Down buttons to move it within the list. You can also directly edit the Order value for this datastore.

4-Repeat the previous step until the datastores are ordered correctly.

From the File menu, select Save All.