Identify the database view ODI uses when loading the journalized data in an Interface.
A.
JV$D view
B.
T$ view
C.
JV$ view
D.
JV$I view
Explanation:
http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/data_capture.htm#CFHFHIAJ
Identify the database view ODI uses when loading the journalized data in an Interface.
Identify the database view ODI uses when loading the journalized data in an Interface.
I agree C is correct.
Ans A JV$D view
Both in case of Consistent set and simple journalizing the view which acts as source of the interface is JV$D
In case of simple journalizing the events are captured directly in JV$D view, so we have to update the journalizing view of physical schema corresponding to the data server as JV$D to allow the interface to read the data from there.
In case of consistent set records which were captured by different events are inserted in the JV$ table. After we perform extend window and lock subscriber the records captured till that moment are inserted into JV$D table and this acts as the source of the interface.
ANS C
When inteface is executed, the generated code appears as follow:
select
SALES.CUST_ID,
JRN_FLAG IND_UPDATE
from SCOTT.JV$SALES SALES
C.
The prefix is defined for each physical schema in Topology.
The default value for it is JV$.
the correct is C
The source table for the journalizing is reading from the JV$ view, where as the data seems to be reading from the JV$D view.
The real reason behind why ODI reads from the JV$ rather than JV$D is that JV$ captures all the records from the JV$D by locking the subscriber.
My Ans is A