Mapping from one to multiple tables while including generated ids
Ok, I have what I believe is a very basic requirement,
I am migrating from a flat table to a set of related tables layout where there is a main entry and a number of sub-entries keyed off main entry PK
So I read from old table , map the fields, write main entry, get generated key, but now I cannot access any of the original data except what was written to main table - which is useless as I need to write data.
Attached is the image of what I am trying to do, I need to add a line from tMap1 to tJoin1 but I am not allowed to.
What obvious thing am I missing?
-HH
Hi all, i want to ask question to all of team in the forum about how to update two different table in job.Because i create script to update some field in the two table. So how i want to use toracle output?
Hi waniJP
For better management, please report a new topic for your question with more details.
Best regards
Shong
