Is Moving data from Greenplum to Oracle for reporting is advisable ?
We are working for one of the leading telecommunication industry for data warehouse and business intelligence reporting , The volume of data is very huge in size(CDR data) and frequency of getting the data are high may be once in a 15 min.
We are using Greenplum as a back-end database to load the data ,Due to Concurrent connection issue in GP (Based on architecture designer's view) the data are migrated back to oracle data base for SAP BO reporting purpose.
With this i have below two questions,
Is really Greenplum database having concurrent connection issue in terms of reporting ?
If so ,
Is moving aggregated fact and Dimension back to oracle is best approach ?