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
- 10391 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
explain one complex mapping with logic? sales project?
Define mapplet?
Explain about cumulative Sum or moving sum?
What is flashback table ? Advance thanks
can we override a native sql query within informatica? How do we do it?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What do you mean by enterprise data warehousing?
How do you use reject loader.
What do you understand by a term domain?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
In development project what is the process to follow for an etl developer from day1
What is Index Caches size?
whats the logic to load the lower level of granularity of data to fact table.
How can we delete duplicate rows from flat files?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
