In an ODI Interface, when defining a join, can you always choose “Ordered Join Syntax”?
A.
Yes, this option is always available.
B.
No, you can never make this choice.
C.
No,this option is inherited from reverse engineering.
D.
No,it may be available if the underlying technology supports it.
Explanation:
I agree A is correct.
http://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm
Both answers are misleading, as is the question.
Yes, you can always check this box as it is never grayed. So technically, A is not wrong.
But no, an ordered join will not be used if the technology doesn’t support it (so D is the right answer).
D is correct