GG related Questions
edited Apr 11, 2013 10:57AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered
When working on Replicat side... Our requirements for receiving data from Golden Gate are as following:
1.We need to have all the transactions in our target tables as separate records.
Example: if 5 records were created in the morning and 3 of them updated later, we need to see 8 records in our table. Meaning that the records always added to the table and not updated.
2.The additional requirement is that we should be able to identify the delta changes (records) that arrive from the Golden Gate. In order to achieve it we need to know if Golden Gate can add a timestamp to each record or a running sequence number so it will be easy to distinguish between older and newer records as they arrive to our tables.
1.We need to have all the transactions in our target tables as separate records.
Example: if 5 records were created in the morning and 3 of them updated later, we need to see 8 records in our table. Meaning that the records always added to the table and not updated.
2.The additional requirement is that we should be able to identify the delta changes (records) that arrive from the Golden Gate. In order to achieve it we need to know if Golden Gate can add a timestamp to each record or a running sequence number so it will be easy to distinguish between older and newer records as they arrive to our tables.
0