Finding of Synthesis Data and Convert to RDB

In this step domain related data set is detected. This identified data set contains information of customer, purchased item and other relative information. This data set gives information of customer purchase behavior and can be in any format and we need to convert into standard common format. To convert to common format detected data set is converted to relational database by using SQL [1] loader. SQL [1] loader is a feature of SQL that helps to convert bulk that into table. In this conversion each sheet of input is converted to single table of oracle. Following steps are performed for this conversion.

Control file contains detail of source file and destination file. It contains a sql loader command that loads data from source to a sql table by giving the detail of input file format and columns. It has structure like follow:

Load data infile “path of input file” into target target_name filldl, field2......fieldn;

load and infile are sql loader keywords.

  • [1] Creation of target container. • Generation of control file contain information for loader. • Execution of sql loader by specifying require parameters.
  • [2] Creation of target container. • Generation of control file contain information for loader. • Execution of sql loader by specifying require parameters.
 
Source
< Prev   CONTENTS   Source   Next >