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
- 8991 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
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?
Can we create a Integration service without a Repository service and vice versa?
Explain sql transformation in script mode examples in informatica
How to load data in informatica ?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Explain the types of lookup transformation?
What is the difference between a repository server and a powerhouse?
Please let me know how to make Data masking in informatica..
What is the session task and command task?
What are connected or unconnected transformations?
Which are the different editions of informatica powercenter that are available?
Difference between Target-based loading and constraint-based loading?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is complex mapping?
What is a grid in Informatica?
