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
- 9097 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sweta kedia
Select EMPID from EMPSAL Where MONTHYEAR IN(SELECT monthyear
from empsal
Group By monthyear
where
sal> 100000)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How do you load first and last records into target table?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Can you use flat files in Mapplets.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What are the limitations of joiner transformation?
What is meant by a domain?
What is an Integration service in Informatica?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is status code in informatica?
How might one distinguish in the case of mapping is right or not without associating session?
Different qualification between a related rotate toward the sky and isolates look upward?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is the difference between a connected look up and unconnected lookup?
What is the maplet?
