Before you can implement Change Data Capture, you need to evaluate your database and tracking needs. You will need to identify source tables and fields for CDC, the CDC level for each policy, and how many storage areas you will need for CDC change tables and indexes.
As you plan your implementation of CDC, consider the following questions:
For which source tables and fields do you need to capture change data?
Which fields of the source tables should be used to create indexes?
In CDC, these fields are referred to as identifying fields. Identifying fields speed up the process of extracting data from the CDC change tables and help to quickly locate related data in the data warehouse for updates.
Which CDC levels should your policies have?
How many storage areas will you need for your CDC data tables and their associated indexes?
For which source tables and fields do you need to capture change data?