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
- 10479 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 |
what are types of dimentions?
Can we create a Integration service without a Repository service and vice versa?
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
Target is zero file and how can you send the email?
What did you do in source pre load stored procedure
Differnce between filter and router?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are events in workflow manager?
If there are more than one sessions running parallel in a worklet, which will be the last session ?
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
Teradata 
