In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal.
Is there any othere transformation than the aggrator? if
yes how?

Answer Posted / eswar

No, In Informatica, you dont have any other transformation
than Aggregator. Aggregator is used for calculatins such as
Avg, Sum which are performed on groups.

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are factless facts? And in which scenario will you use such kinds of fact tables.

1327


What is deployment group?

695


What is workflow monitor?

607


How can a transformation be made reusable?

673


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

819






What is joiner transformation?

591


How does a rank transform differ from aggregator transform functions max and min?

680


What is the difference between informatica 7.0 and 8.0?

577


In how many ways we can create ports?

714


How many ways are there to do 'remove duplicate records in informatica'?

595


Is there any way to read the ms excel datas directly into informatica?

558


How to partition the Session?

654


What are the performance considerations when working with aggregator transformation?

684


How to load the data from people soft hrm to people soft erm using informatica?

571


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1563