hi we will require auditing on changes that are replicated from our source to target. We are trying to find the advantages of using the __ct tables versus using a single audit table. I know that the single audit table already has the changes set up in one field, and the __ct tables require a couple of functions to break those out. But the single table is growing very fast and performance might become an issue.

we are wondering what others are doing. our source is oracle and target is sql server. we have multiple tasks, multiple projects and will most likely have multiple targets. we are just starting out so would like to get some expert opinions on the above.