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
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?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How to join three sources using joiner? Explain though mapping flow.
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is mapplet in informatica?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Differentiate between source qualifier and filter transformation?
Briefly define reusable transformation?
What is update strategy transform?
What is workflow monitor?
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?
When do you use sql override in a lookup transformation?
What is DR strategy for Informatica project?
How is union transformation utilized?
How many numbers of sessions can one group in batches?