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 / 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
what is size of u r database?
What will be the approach?
How we can create indexes after completing the load process?
without table how to come first record only in oracle?
Define pmcmd command?
What does command task mean?
How do you load only null records into target? Explain through mapping flow.
What is a filter transformation and why it is an active one?
How to load data in informatica ?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What are the different ways to implement parallel processing in informatica?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How to handle decimal places while importing a flatfile into informatica?
How identifying bottlenecks in various components of informatica and resolving them?
In warehouses how many schemas are there?