| # Load Without Dumping (bcrun0103m000) Use this session to load the data on the target server. This session can be used in the following two situations: If the source and the target environments are present on two separate servers without a ERP client-server connection and the data files after copying them manually to the target environment server, needs to be loaded into the target database tables. If you need to reload all or some of the data from the data files into the target database tables. When the session starts, all the fields are filled with the values provided in the Conversion Parameters (bcgct0100m000) session, except for the following fields: Process logic After entering the details, click OK to start the loading process. The user authentication dialog box appears. Enter your personal conversion username and password for the authentication. Once you enter the correct user name and password, a dialog box appears to confirm the starting of the process . Click Yes to start the load data only process, or click No to terminate the load data only process. After you start the load data only process, the Filling bccnv400/401/402 tables dialog box appears. Click Stop to stop the load data only process. You have the flexibility to load tables in a particular range, or a particular table. Make the selection by package, by module, or by a table using Select Table Range for Load Only without Dumping (bccnv0205m000) session. After the selection is complete, the system scans for the tables that can be loaded in the range specified. After that, the data loading process starts and the Loading data into the target environment session appears with the progress bar. Note The progress bar does not represent the progress of the loading process in terms of volume of data loaded but indicates the progress based on the number of tables loaded so far. After the loading process is finished, Loading Complete message box appears. The control files (.ctl) are required to provide the input to the native Database Loader in case of Oracle database, about the format of the .dat file from which the data needs to be picked up and loaded into the specific target tables. Type of files generated by the Load Without Dumping (bcrun0103m000) session: Log files : The log files (.log) are created by the native Database Loader for every non empty data file in case of the Oracle database, indicating the result of data loading process from the data files (.dat). The log files (.log) are created in the same directory where the data files are located. After executing the Load Without Dumping (bcrun0103m000) session, log files (.log) must be checked to analyze the reason behind failure to load the data if the bad files (.bad) exist. Using the log file, you can determine the number of rows successfully loaded for a particular table, number of rows not loaded due to data errors and so on. In case there are any rows not loaded due to data errors then the reason behind the failure is also present in the log file and the rejected row(s) data is present in the bad file. Bad files : The bad files (.bad) are created by the Oracle and MSSQL Server native Data Loader in the same directory where the data files are located to specify the records that were rejected due to data errors. These files are created with the name <Target tablename>.bad. Reject Files : These files are created by the Informix Database Loader utility in the same directory where the data files are located to specify which records were rejected due to data errors. This file contains the records that were rejected due to data errors. These files are created with the name <Target tablename>.rej. Related topics Maintain Batch Codes (bcgct8188m000) Conversion Parameters (bcgct0100m000) Tables By Batches (bcgct8189m000) Company Number The target company into which the data must be loaded. Use Database Independent Loaders? Please refer to Use Database Independent Loaders? in Conversion Parameters (bcgct0100m000) session. DBMS Please refer to RDBMS in Conversion Parameters (bcgct0100m000) session. Data Base Home & SID Please refer to Data Base Home & SID in Conversion Parameters (bcgct0100m000) session. Database Please refer to Database in Conversion Parameters (bcgct0100m000) session. Server Please refer to Server in Conversion Parameters (bcgct0100m000) session. Log File Path Please refer to Log File Path in Conversion Parameters (bcgct0100m000) session. User Name of Loader Please refer to Username for Loader in Conversion Parameters (bcgct0100m000) session. Max Rejections The value entered here is used during loading. While loading a table, if the errors encountered are equal to the value entered here then the loading of the table will be terminated. The process of loading continues with the next table available. Pass Word of Loader Please refer to Password for Loader in Conversion Parameters (bcgct0100m000) session. Path of Data Files Enter the path where the data files are located. Date Format This field is applicable only if the target ERP database is Oracle. While creating the data files in Source ERP Environment, a file 'dateformat' is created, which stores the date format in which data is written to the data files. In the absence of that file, the format specified in the field is considered for generating Oracle Control files for loading. Company of ManmanHP Data Current company at the source environment side. Company in which EMM data is stored The Enterprise Modelling data for all the companies can be present in a single company at the target side. The company in which this data is stored must be specified in this field. While migrating the source data, the EMM data is loaded into the tables of that company. same Batch Code The batch code for which you selected Load Without Dumping option in Maintain Batch Codes (bcgct8188m000) session is displayed. Only the table information maintained using Tables by Batches (bcgct8189m000) session for the selected batch code will be considered while performing the loading activity. Store Conversion Run details? If this check box is selected, the conversion run details such as number of records at every conversion phase, time taken for dumping and loading process are stored. Run Number Select the run number from Conversion Run Numbers (bcgct1550m000) zoom-in session where the conversion run details are to be maintained. Dump&Load Time Select this check box if you want to maintain time taken for dumping and loading process. Count records after conversion? Please refer to Count records after conversion? in Conversion Parameters (bcgct0100m000) session. |