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
- 10241 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / sahil
We can use a query,
Select dep_id, sum(salary) from emp group by dep_id;
Here I am using group by because we might have other dep as well.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is it possible to use a client with different version than that of its Informatica server?
Explain what is informatica metadata and where is it stored?
Whats there in global repository
What does cheating measurement mean?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Which transformation should we use to normalise the COBOL and relational sources?
What is primary and backup node?
Performance tuning in UNIX for informatica mappings?
Describe the impact of several join conditions and join order in a joiner transformation?
Performance tuning( what you did in performance tuning)
What are the tasks that can be performed using sq?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What are the different components of powercenter?
update strategy transformation in informatica
Enlist the advantages of informatica.
