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 / 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 to load the data from a flat file into the target where the source flat file name changes daily?
How to Create a folder using pmrep command?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
4 yrs etl devloper roles and responsibilities?any body give solutions
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
what are the deliverables?in your project?
How many ways are there to create ports?
How do you load only null records into target?
Explain the tuning lookup transformation - informatica
What is dimensional table?
What is substr in informatica?
Could you explain what is enterprise data warehouse?
What all are steps in up gradation of Informatica server?