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
- 10609 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
What is DR strategy for Informatica project?
How do you load unique records into one target table and duplicate records into a different target table?
What is a grid in Informatica?
what is the hint? how to use it to reduce the query processing in program?
hi real timers . iam waiting for ur reply regarding ETL TESTING
explain abt ur project architecture?
What does command task mean?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
have u done any performance tuning? how u ll do?
Make a note of the quantity vaults made in informatica?
Explain the informatica workflow?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Briefly describe lookup transformation?
What are the components of the workflow manager?
