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
- 9264 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / animesh
Select EMPID from EMPSAl
Group By monthyear
where
sal> 100000
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
What is the use of target designer?
How do you change a non-reusable transformation to reusable transformation?
Enlist the tasks for which source qualifier transformation is used.
Mention few power centre client applications with their basic purpose?
What is target designer and target load order?
If informatica has its scheduler why using third party scheduler?
What are the new features of informatica 9.x in developer level?
What are the differences between joiner transformation and source qualifier transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is a grid in Informatica?
What are data-driven sessions?
Why do you use Mapping Parameter and mapping variable?
What is sq transformation?
tell me about your project functionality
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
