Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: how to create the target table dynamically

  1. #1
    Join Date
    Sep 2011
    Posts
    12

    Question how to create the target table dynamically

    I have a simple transformation (just a copy) but my source table has receiving new columns (and we don't have this control/information), then I would like to drop and create the target table based on source table every time (before loading). My inputtable is only "select * from source_table" and no fields are mapping. Are there some way or should I create it (a job using the database dictionary maybe)?


    * sorry for my poor english

    thanks
    Gibon

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

    Default

    There is no way because we refuse to write the functionality. It's one of the rare cases where we don't do what community members ask us to do. :-)

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.