CDCView Framework

Custom realization of materilalized view concept based on Oracle Change Data Capture technology. More complex to use than materialized views, but also more flexible. Useful for ETL in Reporitng and DWH solutions.

Usage example:

-- Create CDCView
BEGIN
	cview.create_cview
	(
		psTarget => 'user1.test_cdcv',
		psSource => 'user1.test_order, user1.test_customer(name)',
		psMapPackage => 'user1.map_test'
	);
END;
/

-- Complete refresh
BEGIN
	cview.refresh('user1.test_cdcv', 'c');
END;
/

-- Fast refresh
BEGIN
	cview.refresh('user1.test_cdcv', 'f');
END;
/

More detailed example can be found in folder oralibs/CDCView/doc/example

tags: cdc framework, oracle, change data capture framework

Last edited Jul 12, 2012 at 5:45 PM by alekseiv, version 6

Comments

No comments yet.