The Input File # The input file is a Comma Separated Value (CSV) file and can be created by an extraction program or through standard Windows utilities (e.g. Windows Notepad or Excel). Restrictions to the format of the CSV input file Each field must be separated by comma. , Strings, if the field data contains a comma the whole field must be enclosed in double quotes. " Decimal points must be period. ...
Figure 2 - File Splitter Window File To Split The path of the csv file containing the data that you want to split Split Record Identifier This is the record identifier to be used to mark a split boundary Records Per file User input "Not Mandatory" can select the number of records needed in one file and system would calculate the number of files to be created based on number of records in input file. ...
The Rejected Records File # This file contains all records that were rejected by the migration process. The records written to this file are an exact copy of the rejected records from the input file. After the error that generated the rejected records has been corrected the file of rejected records can be used as the input file for processing. The Error Message File # In this file you will get an explanation as to why your records were rejected. ...
Introduction # One of the main performance problems with migration of data has to do with large number of inserts of new objects into the database using the SQL command interface. The database engine must parse each SQL insert statement. A significant portion (approximately 60%) of the data passed between the client and the server is information to help the parser figure out what kind of data it is, what format it is in, and where it goes. ...
The Oracle Loader # Oracle has a utility for doing bulk-inserts that is called SQLLOAD. If you are connected to an Oracle database server while doing migration, the data files that are output will be in the format required by the Oracle loader. Each file has two sections, the header section and the data section. The header section gives information about the format and destination of the data, including the table, column names, types, order, and format information. ...
Joint Life Cession with retrocessions attached # Load sequence: Load Joint Life Individual Cession (ex: AIC743). Load Individual Retrocession (ex: AIC743-0). Load OCC retrocession (ex: AIC743 and OUT10). It has a link to both the inward cession and the retrocessionaire retrocession Similar logic is used for Individual cessions with retrocessions linked.