Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7 Answers
- 8987 Views
- I also Faced
- E-Mail Answers
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 |
Explain lookup transformation is active in informatica
i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?
How you can differentiate between connected lookup and unconnected lookup?
how can i invoke pmcmd in command line prompt
can anyone explain me about retail domain project in informatica?
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
What is surrogate key?
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
Scheduling properties,whats the default (sequential)
how to calculate the optimum cache size in aggregator transformation?
What are Dimensions and various types of Dimensions?
explain abt joiner t/r?
Teradata 
