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
- 10455 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / rampriya
I think, we can use the source qualifier (active
transformation)- query override
select sum(sal) from emp where dept=10
| Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
What is depict expression change?
what is song in infrmatica...?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is the Process to creating lookup transformation in informatica
What is the difference between router and filter?
Can we create a Integration service without a Repository service and vice versa?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the reusable transformations?
Explain lookup transformation in informatica
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is meant by lookup transformation? Explain the types of lookup transformation?
What is meant by lookup transformation?
What is native users?
Explain lookup transformation is active in informatica
What you know about transaction control transformation?
