Interested to Buy Any Domain ? << Click Here >> for more details...
following scenario empsal table i want who exist one lakshs
sal above monthwise?
`
empsal
empid monthyear sal
1 jan2008 1000
2 march2009 50000
3 april2009 4000
4 feb2009 100000
5 jul2009 600000
6 dec 2008 90000
- 5 Answers
- 9019 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sateesh
select * from empsal GROUPBY ‘monthyear’
HAVING sal>=100000.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
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 performance considerations when working with aggregator transformation?
What all are steps in up gradation of Informatica server?
What is incremental aggregation?
Does an informatica transformation support only aggregate expressions?
How to load the data from people soft hrm to people soft erm using informatica?
What is the reusable transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the different transaction levels available in transaction control transformation?
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?
Which transformation should we use to normalise the COBOL and relational sources?
What is the need for an etl tool?
Is it possible to define a single node as a Gateway node as well as worker node?
What is informatica worklet?
