Difference Between General Purpose and Data Warehouse
Dear Sir/Madam,
In creating database using DBCA there are choices such as Data Warehouse and General Purpose and Transaction Processing. We are creating a report server which includes transactional data and table whose size is almost 80gb, since we do not purge inventory items. May I know what's the difference between the General Purpose and Data Warehouse,. How about the performance? or are there any special set up when using data warehouse? It will be my first time using data warehouse if it suites to y requirements.
Regards,
Dexter
In creating database using DBCA there are choices such as Data Warehouse and General Purpose and Transaction Processing. We are creating a report server which includes transactional data and table whose size is almost 80gb, since we do not purge inventory items. May I know what's the difference between the General Purpose and Data Warehouse,. How about the performance? or are there any special set up when using data warehouse? It will be my first time using data warehouse if it suites to y requirements.
Regards,
Dexter
0