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
- 9323 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How can we improve session performance in aggregator transformation?
Mention some types of transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How many transformations can be used in mapplets.
What are the main issues while working with flat files as source and as targets ?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What are the different components of powercenter?
What does command task mean?
Can we create multiple integration service on single repository?
What is meant by LDAP users?
What is enterprise data warehousing?
What is difference between a gateway node and worker node?
What you know about transaction control transformation?
What is the different lookup cache(s)?
What are ETL Tools?
