Re: Oracle to PostgreSQL - DWH

[Gurudutt Dhareshwar <gurudutt.dhareshwar@xxxxxxxxx>]

Would suggest using snowflakes for DWH

Regards, 

Gurudutt Dhareshwar 

(469-288-7845)

On Feb 12, 2020, at 07:44, Amit jain <amit7.jain@xxxxxxxxx> wrote:



Greenplum is best suited for DW workload,based on Postgresql open source and commodity hardware can also support this.

Postgresql is OLTP DB.

Amit Jain

9833777592

On Wed, Feb 12, 2020, 7:56 PM <soumik.bhattacharjee@xxxxxxx> wrote:

Hi Experts,

 

Greetings!!

 

Did anyone have some use cases for migrating Oracle to PostgreSQL in context to DWH(Data warehousing ) considering 5TB to 8TB database size (Source-Oracle)

 

 

Thanks..