Tutorial corner

Informatica,ETL,oracle,sql/plsql

Aggregator Transformation

Aggregator Transformation in Informatica Without group by

Aggregator Transformation image

Aggregator Transformation in Informatica Without group by : Earlier, we learnt about the Aggregator transformation in Informatica , steps to create it , configuring the port and properties.  We also saw one Example of aggregator Transformation in Informatica mapping .In that example we marked DEPT port as group by port and all calculation was done on group of dept no. Here comes one […]

How to convert rows to columns in Informatica

Aggregator Transformation image

Last time we discussed , how to convert columns to rows in informatica(or in other word Transpose columns to rows) with the help of Normalizer Transformation in Informatica. Now we will  discuss just opposite to it. In below article , we will see step by step example to convert rows to column in Informatica with the […]

Informatica Performance Tuning Tips Aggregator transformation

Aggregator Transformation image

Informatica Performance Tuning Tips Aggregator transformation .Aggregator transformation in Informatica is one of the most popular Informatica Transformation. In below article,we will go through some of the guidelines related to performance tuning of Aggregator Transformation in Informatica. Check here for Lookup transformation performance tuning tips First basic rule for tuning aggregator transformation is to avoid aggregator transformation unless… You really […]

Aggregator Transformation example in Informatica

Aggregator Transformation image

Aggregator Transformation example in Informatica : Earlier , we learnt about the Aggregator transformation in informatica in Informatica , steps to create it , configuring the port and properties. We also discussed the business scenario of Aggregator Transformation in Informatica. Lets see a working Example of Aggregator Transformation in Informatica mapping. Aggregator Transformation example in Informatica Create an informatica mapping to populate min , maximum salary […]

Aggregator Transformation in Informatica

Aggregator Transformation image

Aggregator Transformation in Informatica , is a connected Active transformation which let you performs aggregate calculations, such as averages and sums on the group of data. Aggregator transformation is differ from Expression transformation , as  you use Aggregator  transformation to perform calculations on groups . For example: calculating averages, count first, last, max, median, min, percentile, stddev, sums and variance . The Expression transformation permits you to perform calculations on a […]

Copyright 2015 - Tutorial Corner Frontier Theme