Hi Simon,
This shouldn’t cause any issues and sounds like a solution to an oversized database (however, you can find some other tips around this in this thread). If you do go down the CCAA route, just make sure to keep the data models consistent between CAs so you can query all CAs using CCAA.
Cheers,
Alex