This content has been marked as final. Show 4 replies
What I know is persistence aggregate is used during the poc.. since you are going to implement BI I would suggest to go with database aggregate table.1 person found this helpful
If helps pls mark
Thanks, is there some tool on Oracle Warehouse Buider to help in the construction of the aggregate tables or what do you sugest?
Create DDL scripts for your aggregate tables and run it in your database.
Create ETL mappings to populate these aggregate tables with data. ( You can do this in OWB, Informatica , ODI or any other ETL / ELT tool)