Page 1 of 1
Table Updates from Schema File
Posted: Thu Apr 19, 2018 8:26 am
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?
Posted: Thu Apr 19, 2018 10:01 am
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?
Posted: Thu Apr 19, 2018 9:45 pm
by ray.wurlod
Would there be a separate schema file for each table? If so, you could define the Key columns in that.