Bookshelf Home | Contents | Index | PDF |
Siebel Life Sciences Guide > Importing Data into Life Sciences > Importing, Extracting, and Routing Syndicated Data > Using SQL*Loader to Load the DataData records in Siebel Business Applications do not refer to the row ID field in the S_SYND_DATA table. You can insert any value in this field if it is unique in the record. Therefore, you can use a native database utility to populate this table. This method discusses the use of the Oracle SQL*Loader utility. As with the Visual Basic and COM method, using SQL*Loader requires that you resolve the foreign key references either before or after the data has been loaded into the table. To use SQL*Loader to load the data
This code updates the Period field in the Syndicated Data Table to the ID of the Period rather than to the textual description of the period. You must modify and run this code for each foreign key field referred to in Table 23. The code only needs to be run for each field that you load, not for all of the fields. |
Siebel Life Sciences Guide | Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |