Hello,
I am having a requirement to send a daily updated customer details or newly created customer details to a third party as batch file.
1. if the customer is already sent then we should be sending only the data in the columns that has been changed rather then the complete customer details.
2.If the customer is a new customer then i need to send his complete details.
I am on oracle 10g database and i need to do this daily as a overnight batch.
I am thinking of using couple of options
1. use DBMS_CDC_UTILITY
but this is needs a staging area where we need to create the stage tables.
Can you please help me what can be the best possible option to satisfy this requirement.
Please advice .
Thanks.