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

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1513


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1922


How to join three sources using joiner? Explain though mapping flow.

704


Can we change Dynamic to Static or Persistent cache? If so what happens?

1730


What is mapplet in informatica?

598






What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

609


Differentiate between source qualifier and filter transformation?

1003


Briefly define reusable transformation?

629


What is update strategy transform?

580


What is workflow monitor?

604


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

554


When do you use sql override in a lookup transformation?

591


What is DR strategy for Informatica project?

706


How is union transformation utilized?

572


How many numbers of sessions can one group in batches?

625