0 Replies Latest reply on Jan 9, 2013 5:34 PM by 931546

    Create New Fields in Stage or Target Table

      Hello, I would like to ask how can I create some new fields in my table and fill them with some of my source data using a SQL expression.

      My source data tables are under ODBC Module and I have created a staging table under the Oracle Module to load my source data.

      I wonder whether I should create the extra fields in the staging table or in the target table and how do I fill them using SQL.

      I am a bit amateur and trying to learn. Thank you.