Table Updates from Schema File

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ETLHMC
Premium Member
Premium Member
Posts: 10
Joined: Fri Oct 14, 2011 11:42 am
Location: Pennsylvania

Table Updates from Schema File

Post by ETLHMC »

I have several delimited files that I want to use to update an Oracle table using RCP and a schema file. Each table has a different set of keys and each file has different columns. Is it possible to do this dynamically?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Just wanted to check first - do you have experience working with RCP jobs or would this be your first foray into that area?
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Would there be a separate schema file for each table? If so, you could define the Key columns in that.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply