GO DIRECTLY TO
My Oracle Support Community
Oracle Technology Network
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jan 9, 2013 9:34 AM by 931546
Create New Fields in Stage or Target Table
Jan 9, 2013 9:34 AM
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.
Track in Communications
- 10 points
- 5 points