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
- 7199 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
What are different types of transformations available in informatica?
server hot-ws270 is connect to Repository B. What does it mean?
Could you explain what is enterprise data warehouse?
What is the difference between Active and Passive transformation?
What is informatica worklet?
Performance tuning( what you did in performance tuning)
What is a passive transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are the differences between joiner transformation and source qualifier transformation?
What do you mean incremental aggregation?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
can u any challenge your project?
What is meant by LDAP users?
