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
- 10444 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
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What do you mean by enterprise data warehousing?
What do you mean by blocking transformation?
How can a transformation be made reusable?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What do you understand by term role-playing dimension?
What is resilience time?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
If informatica has its scheduler why using third party scheduler?
What is different between the data warehouse and data mart?
Explain the tuning lookup transformation - informatica
Do you find any difficulty while working with flat files as source and target?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
