Method and device for generating ETL codes

The invention relates to a method and device for generating ETL codes, and the method comprises the steps: setting a data processing process and a processing rule according to the mapping relation between a source data model and a target data model, defining the mapping relation through employing existing tool software, and exporting the mapping relation to a mapping relation table; loading data required in the data source into the mapping relation table, analyzing the data, numbering the analyzed mapping relation according to the processing batch and the processing group, and importing the numbered mapping relation table into a target database; automatically generating a detailed mapping file by adopting a core algorithm; automatically generating a parameterized SQL script according to the detailed mapping file; generating a script as a Python code according to the defined Python program template, transmitting the connection information of the target database in a configuration file mode, packaging the SQL f