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
- 8982 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 | 4 No |
Post New Answer View All Answers
Scheduling properties,whats the default (sequential)
How can a transformation be made reusable?
What is mapping debugger?
How can we update a record in the target table without using update strategy?
What is informatica worklet?
What are the different types of olap? Give an example?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Define update strategy?
Which files are created during the session rums by informatics server?
What is mapplet in informatica?
Differentiate between source qualifier and filter transformation?
What do you mean by blocking transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are the types of presistent cache in look up tr.
