if we have input eno 1,2,3,1,2,3 year
2001,2002,2003,2001,2002,2003 and sal
10000,20000,30000,20000,30000,40000
ex-output
eno totsal
1 30000
2 50000
3 70000
Answers were Sorted based on User's Feedback
Answer / sujana
@above
wer do we calculate sum here..i think v shud create an o/p
port 4 sum.(sum sal) and grpby eno
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / chandra
After the source qulifier take Aggr t/r pass all the ports
to th Aggr t/r. group by eno & year.Add a new out put port
in this derive the logic as sum(sal) & pass to the Target
Def.
I think this would work.
Regards,
Chandra
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / narendra
in source qulifier we override query like this
select eno,sum(sal as totsal)from emp group by eno
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / ankit kansal
In Aggregator Transformation Create an output Port name TOTSAL, And in front of eno port check group by and in TOTSAL column use SUM(sal)
http://deepinopensource.blogspot.in/
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / lakshmi
Use aggrigator transformation group by port as eno
Is This Answer Correct ? | 1 Yes | 3 No |
Answer / suresh reddy
select eno,sal,sal+sal as totsal from ex GROUP BY sno,sal;
will give the output same as above
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / suresh reddy
select eno,sal,sal+sal as totsal from ex GROUP BY sno,sal;
will give the output same as above
Is This Answer Correct ? | 0 Yes | 4 No |
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is olap (on-line analytical processing?
Difference between session variables and workflow variables?
Explain sessions and how many types of sessions are there?
plz plz plz send client names and project names in informatica?
what is hash table in informatica?
I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?
What is the difference between SOURCE and TARGET BASED COMMITS?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
can we override a native sql query within informatica? How do we do it?