Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 10464 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / arun kumar
Hey Friend,
First try to understand the query first.Here we need to calculate the sum salary of 5 members from deptno 10 with using Aggregation Transformation in informatica.
Yes, we can calculate group of records with our using aggregator by taking 2 sorter transformation and 2 expression transformations and 1 filter transformation.
I have done this with using 5 transformations and it worked.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
In informatics server which files are created during the session rums?
Can we get 1st record through Informatica(without sequence number).
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is decode in static cache?
What are the designer tools for creating transformations?
In how many ways we can create ports?
What is xml source qualifier transformation in informatica?
tell me about your project functionality
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How might you approve all mappings in the archive all the while?
Describe the impact of several join conditions and join order in a joiner transformation?
What is the advantage of informatica?
what is $$$$?
What could be the possible resons of locks by user?
