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
- 10469 Views
- Patni, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rampriya
I think, we can use the source qualifier (active
transformation)- query override
select sum(sal) from emp where dept=10
| Is This Answer Correct ? | 10 Yes | 3 No |
Answer / 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 |
Answer / 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 |
Answer / eswar
No, In Informatica, you dont have any other transformation
than Aggregator. Aggregator is used for calculatins such as
Avg, Sum which are performed on groups.
| Is This Answer Correct ? | 2 Yes | 5 No |
Answer / talluru.sankar naidu
we can use SQ transformation write the query we get ans
select sun(sal) from emp where deptno=10 and deptno=5;
I think its correct
| Is This Answer Correct ? | 1 Yes | 8 No |
In operator is used in which transformation in informatica 8.6.0
What is difference macros and prompts?
when we use dynamic lookup,if condition matches what will be the o/p?
How can we improve session performance in aggregator transformation?
What is a poling?
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
In which circumstances that informatica server creates Reject files?
What is deployemnt groups, Lables, query and dynamic deployment group.
Parameter and variable differences
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
Teradata 
