RE: Oracle to PostgreSQL - DWH

[<soumik.bhattacharjee@xxxxxxx>]

Migration is fine, but is PostgreSQL good for DWH use cases ?

 

Can PostgreSQL support data warehousing loads?

 

From: John Wiencek <jwiencek3@xxxxxxxxxxx>
Sent: woensdag 12 februari 2020 16:31
To: Bhattacharjee, Soumik <soumik.bhattacharjee@xxxxxxx>
Cc: pgsql-admin@xxxxxxxxxxxxxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: Oracle to PostgreSQL - DWH

 

EnterpriseDB has a product called Migration Toolkit (MTK) that can do this.

 

 

John

On Feb 12, 2020, at 8:25 AM, <soumik.bhattacharjee@xxxxxxx> <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..