select eno,sal,sal+sal as totsal from ex GROUP BY sno,sal; will give the o

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

Question Posted / suresh reddy

7 Answers
9328 Views
I also Faced
E-Mail Answers

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

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we create a Integration service without a Repository service and vice versa?

1260

What are the types of lookup transformation?

1120

Can anyone tell me the new features in Informatica 9 Version?

2214

What is the reusable transformation?

1103

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1155

What is an expression transformation?

1080

draw informatica architecture 8.6 ?

3932

What are the types of data warehouses?

1577

What are the performance considerations when working with aggregator transformation?

1210

What is informatica metadata and where is it stored?

1045

Target increases every day even though no new record was inserted

1626

Which transformation is needed while using the Cobol sources as source definitions?

1221

What is decode in static cache?

1264

What is informatica etl tool?

1061

How do you use reject loader.

2651