How can you implement near real time data integration with Oracle Data Integrator?
A.
By accessing Change Data Capture records from logs
B.
By using Exchange Partition
C.
By mining Oracle UNDO segments
D.
By reading operating system logs
Explanation:
Conventional Extract, Transform, Load (ETL) tools closely intermix data
transformation
rules with integration process procedures, requiring the development of both data
transformations and data flow. Oracle Data Integrator (ODI) takes a different approach to
integration by clearly separating the declarative rules (the what) from the actual
implementation (the how). With ODI, declarative rules describing mappings and
transformations are defined graphically, through a drag-and-drop interface, and stored
independently from the implementation. ODI automatically generates the data flow, which
can be fine-tuned if required. This innovative approach for declarative design has also been
applied to ODI’s framework for Changed Data Capture. ODIs CDC moves only changeddata to the target systems and can be integrated with Oracle GoldenGate, thereby enabling
the kind of real time integration that businesses require.
Reference: Best Practices for Real-time Data Warehousing, Oracle White Paper