How can you implement near real time data integration with Oracle Data Integrator?

Question

Options

• ABy accessing Change Data Capture records from logs
• BBy using Exchange Partition
• CBy mining Oracle UNDO segments
• DBy reading operating system logs

• A
  77% (50)
• B
  3% (2)
• C
  12% (8)
• D
  8% (5)

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. ODI's CDC moves only changed data to the target systems and can be integrated with Oracle GoldenGate, thereby enabling the kind of real time integration that businesses require.

No community discussion yet for this question.