Customer Portal

Mload in Clover Etl

Comments 4

  • Avatar
    avackova
    0
    Comment actions Permalink
    Hello,
    CloverETL doesn't have Teradata bulk loader. To load data from Oracle to Teradata, you need to unload data from Oracle with DBInputTable and load it to Teradata with DBOutputTable.
  • Avatar
    dpavlis
    0
    Comment actions Permalink
    You could use SystemExecute to funnel CloverETL data records into mload. SystemExecute allows you to read records from input port, format them into text representation and then send them through STDIN to mload for uploading into DB.

    You may also look at Clover's Oracle bulk loader and just modify it for mload. Mload seems to allow reading data from STDIN which makes this a lot easier.
  • Avatar
    mohankrishnas
    0
    Comment actions Permalink
    hi ,

    Could you tell me how to use this systemexecute . What should be given in the system command
  • Avatar
    dpavlis
    0
    Comment actions Permalink
    Hi,

    Check our wiki: http://wiki.cloveretl.org/doku.php?id=components:others#system_execute

Please sign in to leave a comment.