Scribd
Upload
8 views10 pages

Informatica Expression & Aggregator Guide

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.

Uploaded by

Deepak Kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views10 pages

Informatica Expression & Aggregator Guide

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.

Uploaded by

Deepak Kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

INFORMATICA

EXPRESSION TRANSFORMATION

 Import source tables – EMP

 Define Target table – EMP_EXP

1 [Link]@[Link]
99520 29030
INFORMATICA
 Create a New Mapping for EMP_EXP

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

2 [Link]@[Link]
99520 29030
INFORMATICA
 Drag all the Required columns from Target to Expression

 All the Required columns now available in Expression

3 [Link]@[Link]
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 [Link]@[Link]
99520 29030
INFORMATICA
 Connect all columns from Expression to Target

 Create a workflow and exec using start workflow

5 [Link]@[Link]
99520 29030
INFORMATICA
 Validate the Target data using TOAD

6 [Link]@[Link]
99520 29030
INFORMATICA
AGGREGATOR TRANSFORMATION
 Define the Source – EMP

 Define a Target table – EMP_AGG

7 [Link]@[Link]
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 [Link]@[Link]
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 [Link]@[Link]
99520 29030
INFORMATICA
 Create and execute the workflow

 Validate the data using TOAD

10 [Link]@[Link]
99520 29030

You might also like