This discussion is archived
0 Replies Latest reply: Jan 9, 2013 9:34 AM by 931546 RSS

Create New Fields in Stage or Target Table

931546 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points