Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How to load multiple tables ?

  1. #1
    Join Date
    Jun 2010
    Posts
    114

    Default How to load multiple tables ?

    I have say 10 tables in Database A which has different number of rows and columns.
    I need to load all of these to a different Database B.
    Do I need to write 10 different transformations to do this? or, is there a better way?
    Thanks,
    Om
    ----------------------
    Spoon version -4.4.0

  2. #2
    Join Date
    Dec 2009
    Posts
    609

    Default

    Hi Om,

    in the Spoon-Menu, check the Wizards entry. There is a "copy tables" wizard to be found, which can automatically create such a transformation
    for you...

    Best regards,

    Tom

  3. #3
    Join Date
    Jun 2010
    Posts
    114

    Default

    That sounds great
    Thanks Tom

    Regards,
    Om

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.