Oracle Data Import: Edit Feature Class Properties

In the mapping definition for a feature class, you specify properties as shown in the following table.

Property	Description
Include In Mapping Definition	Includes the settings in the mapping definition.
Migration Method	Specifies the migration method. Add As A New Feature Using API: Inserts each feature separately. This method guarantees data consistency. No post processing is required. Use this method to migrate a small amount of data. Add As A New Feature Using Map API: Inserts each feature separately. This guarantees data consistency but may be slower. Use this method to use coordinate transformation for Configuring Oracle Data Import. Add A New Feature Using SQL Loader: This method inserts the data from SQL Loader files. For each feature class, Insert statements are created, so that client-side feature rules would not be applied. For example, use this method to find a single record that stops the data transfer. Add As A New Feature Using Insert Statement: This method creates an insert statement per feature class, so that client-side feature rules are not applied. This is the fastest method. For example, if you migrate a large amount of data. This method usually requires post processing. Update Existing Feature Using Filter: Define an SQL filter expression that is added in the WHERE part of the SQL select statement. You can use the alias "a" for the table name. You can use placeholders for parameters. See Oracle Data Import: SQL Statements and Placeholder.
Filter	Use a filter to import a project. For example, for each feature class, use the filter IMPORT_ID = {IMPORT_ID}. Then, the import process replaces the value of the parameter {IMPORT_ID} with the value corresponding to the selected project.
Comments	Stores any comments, for example, that explain why a method has been chosen.

Migration Model - Using a filter—For example, select the Update Existing Feature Using A Filter option, if you need to update existing data instead of inserting data.

Sample scenario: Database A stores parcel data, database B stores additional data for the same parcels. To migrate the parcel data, you execute two migration steps.

• Execute a standard Insert for database A.
• Execute an Update statement to add the additional data from database B. Enter the SQL select statement that defines the relation of the source table and the final table.

Use the alias "s" for the source table and the alias "t" for the final table. For Example:

s.fid = t.fid
s.flur=t.flur and s.stammnummer=t.stammnummer and s.unternummer=s.unternummer

Using these expressions, the following Update statement is used.

 update AL_F_FLUR t SET (NAME,KENNUNG) = 
(SELECT NAME,KENNUNG FROM AL_F_FLUR s WHERE s.fid = t.fid)

In this case the attributes NAME and KENNUNG have been selected in the dialog box.

You can use placeholders, see TB2TB: SQL Statements and Placeholder.