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?
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 |
What is difference between maplet and reusable transformation?
how to through logic of informatica using the push down optimization into oracle.
what is session override?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How many repositories can we create in Informatica?
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
What is the sequence generator transformation in informatica?
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
How to open an older version of an object in the workspace?
Could any one to tell How to use the Oracle Analytic functions in Informatica?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.