Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Sunday, 8 September 2013

Aggregator Transformation in Informatica


By on 09:24:00




Aggregator is an active transformation used to calculate group values.

Ports:

· Input

· Output

· Expression

· Variable

· Group By

Properties:

· Data Cache

· Index cache

· Sorted Input

Steps:

1. Define Source

2. Define Target

Write the Target requirements and Generate/Execute SQL.

AGG_FACT 

· DEPTNO

· TOT_SAL

· MAX_SAL

· MIN_SAL

· AVG_SAL

· COUNT_EMP


Aggregator Transformation in Informatica
Aggregator Transformation in Informatica





Add the required ports like TOT_SAL, MAX_SAL etc.
Aggregator Transformation in Informatica
Aggregator Transformation in Informatica



3. Define Mapping M_AGG

4. Drag Source and Target to the Mapping Designer.

5. Go to the Transformation Menu and click on Create. Select the Transformation type as AGGREGATOR T_AGG.


Aggregator Transformation in Informatica
Aggregator Transformation in Informatica


6. Project the required ports from Source Qualifier to the Aggregator.


Aggregator Transformation in Informatica
Aggregator Transformation in Informatica


7. Edit Aggregator. Go to Ports Tab

Uncheck inputs for all added ports. (Expressions are highlighted)

In the functions tab Aggregate folder is displayed only when it is used in the mapping.
Aggregator Transformation in Informatica
Aggregator Transformation in Informatica

Aggregator Transformation in Informatica
Aggregator Transformation in Informatica



In the Functions tab expand Aggregate folder. Select the function. From the Ports tab select the port.

Validate -> OK.

Apply the functions to respective ports.

Check the Group By check box for the department.


In the Properties tab check the box Sorted Input if the data is already sorted (suppose sorter tranfn is applied before the aggregator, otherwise the agg will sort the input)
Aggregator Transformation in Informatica
Aggregator Transformation in Informatica


Aggregator Transformation in Informatica
Aggregator Transformation in Informatica


Aggregator Transformation in Informatica
Aggregator Transformation in Informatica


Project the required ports from the aggregator to the taget.

Save the Repository.

Create a Session S_AGG

Define a Workflow WF_AGG.

Start the workflow.

Preview the data.
Aggregator Transformation in Informatica
Aggregator Transformation in Informatica





3 comments:

  1. gud explanation ... can you just brife out first and last function and incremental aggregation with an example

    ReplyDelete
  2. Nice blog thanks for sharing..!

    ReplyDelete
  3. Aggregated is the type an active transformation which allows you to calculate the summary’s for a group of records.Provided information on Aggregator Transformation is good

    ReplyDelete

Blog Archive

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (46) Informatica Online Training (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (1) OBIEE 10G (8) OBIEE 11G (137) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)