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
Answer Posted / 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 |
Post New Answer View All Answers
Explain the tuning lookup transformation - informatica
What is a predefined event?
How are the sources and targets definitions imported in informatica designer?
How to join three sources using joiner?
What is meant by lookup transformation? Explain the types of lookup transformation?
How you can differentiate between connected lookup and unconnected lookup?
What is target designer and target load order?
wf dont have integration severances how you can run?
What is a sorter transformation?
Write the program through which the records can be updated?
Can u generate reports in Informatica?
list out all the transformations which use cache?
where to store informatica rejected data?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How to convert multiple rows to single row (multiple columns) in informatica