Data loading to GreenPlum using gpfdist(Greenplum file dist)
Posted: Thu Jan 30, 2014 9:42 am
Hi All,
I am trying to load Oracle data to GreenPlum using ODBC driver, for loading 50 million records it took 27 hrs.
Did some one have any experience in using gpfdist(Greenplum file distribution) in DataStage for bulk loading the data.
Thanks
Sundar.
I am trying to load Oracle data to GreenPlum using ODBC driver, for loading 50 million records it took 27 hrs.
Did some one have any experience in using gpfdist(Greenplum file distribution) in DataStage for bulk loading the data.
Thanks
Sundar.