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