Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to copy data from oracle source to greenplum table faster.

  1. #1
    Join Date
    Jun 2014
    Posts
    7

    Question How to copy data from oracle source to greenplum table faster.

    Hi,

    Currently i am using pdi steps to transfer data from oracle source to my greenplum tables, but the data is huge and taking time to load.
    So to reduce the load time what should i do.......is there any script to sync data from oracle to greenplum,....means directly copy the data from
    oracle to greenplum using any unix script.
    please help.

    Thanks

  2. #2

    Default

    Try using GP bulk load step. Check also distribution columns to avoid data skew
    blog: http://anonymousbi.wordpress.com
    twitter: https://twitter.com/pentaho_fan

    @Pentaho_Fan....also called David Fombella

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.