How can you accomplish this?

You are defining a data store in ODI metadata and want to add a primary key even if it does not physically exist on the related database catalog.
How can you accomplish this? (Choose the best answer.)

You are defining a data store in ODI metadata and want to add a primary key even if it does not physically exist on the related database catalog.
How can you accomplish this? (Choose the best answer.)

A.
You can add a primary key even if it does not physically exist on the related database catalog, by adding constraints on the data store.

B.
You can add a primary key even if it does not physically exist on the related database catalog, by adding constraints to the data store diagram.

C.
You cannot add a primary key if it does not physically exist on the related database catalog. You can flag only non-null conditions to be checked.

D.
You cannot add a primary key if it does not physically exist on the related database catalog. You can reverse engineer only the existing constraints.

Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIKM/teradata.htm#ODIKM1061)



Leave a Reply 2

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