Scribd Logo
Upload

Welcome to Scribd!

  • 23 views

    Informatica: Import Source Tables - EMP

    Uploaded by

    Deepak Kumar
    The document describes using Informatica to perform expression and aggregation transformations. It involves importing source data, defining target tables, creating mappings to drag columns between source, expression/aggregate components and target, applying expressions and aggregation functions, linking columns to the target, and validating the output data. The target of the expression transformation is to transform source columns to new columns using expressions. The aggregation transformation is used to aggregate source columns and apply functions to calculate totals.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Informatica: Import Source Tables - EMP

    Uploaded by

    Deepak Kumar
    23 views10 pages
    The document describes using Informatica to perform expression and aggregation transformations. It involves importing source data, defining target tables, creating mappings to drag columns between source, expression/aggregate components and target, applying expressions and aggregation functions, linking columns to the target, and validating the output data. The target of the expression transformation is to transform source columns to new columns using expressions. The aggregation transformation is used to aggregate source columns and apply functions to calculate totals.

    Original Title

    Exp_Agg_Trans

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes using Informatica to perform expression and aggregation transformations. It involves importing source data, defining target tables, creating mappings to drag columns between source, expression/aggregate components and target, applying expressions and aggregation functions, linking columns to the target, and validating the output data. The target of the expression transformation is to transform source columns to new columns using expressions. The aggregation transformation is used to aggregate source columns and apply functions to calculate totals.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    23 views10 pages

    Informatica: Import Source Tables - EMP

    Uploaded by

    Deepak Kumar
    The document describes using Informatica to perform expression and aggregation transformations. It involves importing source data, defining target tables, creating mappings to drag columns between source, expression/aggregate components and target, applying expressions and aggregation functions, linking columns to the target, and validating the output data. The target of the expression transformation is to transform source columns to new columns using expressions. The aggregation transformation is used to aggregate source columns and apply functions to calculate totals.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 10

    INFORMATICA

    EXPRESSION TRANSFORMATION

     Import source tables – EMP

     Define Target table – EMP_EXP

    1 sairavi.etl@gmail.com
    99520 29030
    INFORMATICA
     Create a New Mapping for EMP_EXP

     Drag and Drop all columns from SQ to EXP and Target

    2 sairavi.etl@gmail.com
    99520 29030
    INFORMATICA
     Drag all the Required columns from Target to Expression

     All the Required columns now available in Expression

    3 sairavi.etl@gmail.com
    99520 29030
    INFORMATICA
     Enable Output Ports and Disable Input port for all the
    new columns

     Enter the expression in the Corresponding columns as


    per the logic

    4 sairavi.etl@gmail.com
    99520 29030
    INFORMATICA
     Connect all columns from Expression to Target

     Create a workflow and exec using start workflow

    5 sairavi.etl@gmail.com
    99520 29030
    INFORMATICA
     Validate the Target data using TOAD

    6 sairavi.etl@gmail.com
    99520 29030
    INFORMATICA
    AGGREGATOR TRANSFORMATION
     Define the Source – EMP

     Define a Target table – EMP_AGG

    7 sairavi.etl@gmail.com
    99520 29030
    INFORMATICA
     Create a New mapping for Aggregator

     Drag and Drop Required columns from SQ to AGG and


    Additional columns from target to Agg

    8 sairavi.etl@gmail.com
    99520 29030
    INFORMATICA
     Enable Output Ports and Disable Input port for all the
    new columns and Apply Required functions based on
    your requirement document

     Link required columns from Agg to target and enable


    group by for non-aggregated columns

    9 sairavi.etl@gmail.com
    99520 29030
    INFORMATICA
     Create and execute the workflow

     Validate the data using TOAD

    10 sairavi.etl@gmail.com
    99520 29030

    You might also like