We have multiple dimensional and fact tables in Exadata. The requirement is to perform CDC on certain attributes from these 5 different dimensional and fact tables. So basically, we will have to collate all the required attributes from 5 different tables and perform CDC on daily basis. My question here is -
If I have to create one unique history table with all the required attributes from the 5 different tables(dimensional & fact), then creating the daily incremental table from the same attributes will be a pain, which would take whole lot of time. Is there a better way to achieve this instead of creating the history and incremental load separately from the existing tables? And is it a good idea to create a unique table combining both dimensional and fact tables?