How to implement CDC in Datastage Server ?
Posted: Thu Dec 16, 2010 9:59 am
Hi-
In past I've used CDC stage to do change data capture in PX at a table level but now I need to know how CDC could be implemented using server edition. Also, my requirement is to do CDC at the schema level, in other words I need to know what records have been inserted, updated or deleted from all transactional tables of that schema and bring that data to staging area. The count of transactional tables is close to 300 and generally total record count of each table is close to 10 million records.
If I decide to go for 8.x server , will there be any difference in implementation of CDC described above?
Thanks in advance.
In past I've used CDC stage to do change data capture in PX at a table level but now I need to know how CDC could be implemented using server edition. Also, my requirement is to do CDC at the schema level, in other words I need to know what records have been inserted, updated or deleted from all transactional tables of that schema and bring that data to staging area. The count of transactional tables is close to 300 and generally total record count of each table is close to 10 million records.
If I decide to go for 8.x server , will there be any difference in implementation of CDC described above?
Thanks in advance.