| Loading two tables - master/detail problem- HELP!! [message #72285] |
Thu, 01 May 2003 13:55 |
Lise
Messages: 1
Registered: May 2003
|
Junior Member |
|
|
We have data to be loaded in two tables using SQL LOADER
(ce_statement_headers_int_all nd ce_statement_lines_interface). The file sent
by our bank comes with only 1 account number. There is no specifications of
which row is identified as the header or as detail because they are in fact all
details lines transactions. We do not want to populate the tables with multiple
statement numbers (i.e. each statement line with a 1:1 relationship with the
statement header). Is there a way to update the master table with the same
primary key without getting the constraints errors? Can we limit the update of
the master table on the first row of data only
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
