Source Generator

Version 1


    Source Generator is a utility that generates source data for all the major databases (like Oracle, Sybase, DB2 and Microsoft SQL Server) and flat files. The sources can be the source XML or Mapping XML. The unique feature of this utility is when the Source Type is a Database, the Target can be generated either in a database or in a flat file.

    Purpose/ Usage

    The purpose of Source Generator is to generate random data for the given source file by recognizing the definition of the source. While generating the data (in a database), if a table already exists, either the rows are appended to the table or a new table is created.The data can be directly loaded to the database table or can be stored into a sql file( csv file). The utility takes the table definition from the powercenter xml mapping of table. The log can be viewed on the Output Window on the utility.

    Prerequisites/System Requirements

    • Table should exists in the database.
    • Powercenter xml mapping for table.

    Supported Infa products

    • PowerCenter
    • Data Quality
    • IIR
    • Any products which have feature of generating mapping XML file


    License Info

    • Free download

    Current Version

    • Source Generator 1.0



    How to Install

    The Parameters to use the utility are:

    1. XML Source Export: Click Browse File to select Informatica Source or Mapping XML which has source definition.
    2. Source DB Type: The Source DB Type can be two types. They can be a Database file or a Flat file. When you select the XML file, the database type is automatically fetched from the XML file and displayed in Source DB Type.
    3. Target Type: The Data can be generated to either a Database or a Flat File by selecting one of the radio buttons.
      • If the Source DB Type is Flat File, the target type can only be a flat file. You can generate data to only flat file by specifying the location of the file to be generated. You can specify the file by clicking the Select Directory against Output File Name field.
      • If the Source DB Type is a Database, the DB Connection field will be activated. In the DB Connection field follow the steps given below:
        1. Select the valid DSN Name from the given list and if the DSN has to be created from the tool, click on the   button.
        2. Enter proper DB User Name, DB Password for the corresponding DSN entry selected and click the button to connect to the database.
      • If the Source DB Type is a Database (Oracle, Sybase, DB2 and Microsoft SQL Server) and the target type is a Flat File, specify the location of the file to be generated by clicking on Select Directory against the Output File Name field.
    4. Specify the No. of Rows to be generated for the selected source.
    5. Click on the Generate Source button to generate source data.
    6. Click the Clear button to delete all the selected fields.
    7. Click Close button to close the window.
    8. The Output Window displays the log and other necessary details.


    Known Limitations

    1. Only one source definition is allowed in the XML file. If more than one source definition is found, the data is generated only for first source definition found in the XML file.
    2. No. of columns is limited to 500.
    3. Takes 20 seconds to generate 1000 rows for relational source of 15 columns.
    4. Generates random data.
    5. Only native drivers can be used to generate data. DSN entry created for ODBC drivers or any other drivers cannot be used to generate data. To generated source data for relational sources, respective clients needs to be present in the system where this utility is running.
    6. The utility does not work for date and timestamp datatype.
    7. The performance degrades as the no if rows increases.

    Release History


    Sl No.

    Version History




    Support Platforms


    Supported Database and Data Types:


    • Oracle: char, date, long, nchar, number, number (p, s), nvarchar, varchar, varchar2.
    • DB2: char, date, decimal, float, integer, long varchar, numeric, small int, varchar.
    • Sybase: char, datetime, decimal, float, int, nchar, numeric, nvarchar, real, smalldatetime, small int, text, tinyint, varchar.
    • Micorsoft SQL Server: char, datetime, decimal, float, int, nchar, ntext, numeric, nvarchar, real, smalldatatime, smallint, text, tinyint, varchar.
    • Flat-File: datetime, string, number, nstring.