Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Creating a New Table

  1. #1

    Default Creating a New Table

    HI,
    I have a one to one sync up transformation. I have created a target table with the required structure and loaded the data. Please let me know, if there is an option in the transformation to create the target table, instead of creating it manually in the Database.

    Thanks in Advance!

  2. #2
    Join Date
    Nov 2009
    Posts
    687

    Default

    With the SQL button in the table output step

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    And you can paste the generated SQL in a SQL Job entry.

  4. #4

    Default

    Thanks a lot!!
    Is there any option to alter an existing table?

  5. #5
    Join Date
    Nov 2009
    Posts
    687

    Default

    When the table already exist then the SQL button can also alter the table. It checks of the output fields are from the same layout as the table itself. So when you added an field the table wil be alterd. In the Insert/Update step it also creats an index.
    An other way is what Mat suggested, an SQL job entry

    Johan

  6. #6

    Default

    Thanks a lot!!!

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.