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.
The correct answer should be A.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. I am not sure what they mean by diagram but keys are added from expanding model tree>datastore tree> Constraints Node.
@k_Y this method is used to create alternate keys on data stores where you could possible define uniqueness on an alternate but still this is not primary key. In my opinion the answer is D
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
k_Y
Highly Voted 2 years, 2 months agogbmk
Most Recent 6 months, 3 weeks agogbmk
6 months, 1 week agonavi7512
9 months ago