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
- 10238 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / arun kumar
Hey Friend,
First try to understand the query first.Here we need to calculate the sum salary of 5 members from deptno 10 with using Aggregation Transformation in informatica.
Yes, we can calculate group of records with our using aggregator by taking 2 sorter transformation and 2 expression transformations and 1 filter transformation.
I have done this with using 5 transformations and it worked.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What are the advantages of informatica?
Explain what is informatica metadata and where is it stored?
Why is sorter an active transformation?
What is a predefined event?
where to store informatica rejected data? How to extract the informatica rejected data?
Explain the different lookup methods used in informatica?
What is Data Caches size?
How might one distinguish in the case of mapping is right or not without associating session?
Which are the different editions of informatica powercenter that are available?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Explain scd type 3 through mapping.
What is intricate mapping?
What does cheating measurement mean?
Explain lookup transformation in informatica
