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
- 9262 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
Explain informatica architecture - version 8 / 9
How many types of sessions are there in informatica.please explain them?
What does “tail –f” command do and what is its use as an Informatica admin.
Define update strategy?
can we override a native sql query within informatica? How do we do it?
What is joiner transformation?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What does update strategy mean, and what are the different option of it?
Why update strategy and union transformations are active? Explain with examples.
What is informatica powercenter repository?
EXL informatica Questions
What is the use of source qualifier?
What is DR strategy for Informatica project?
How does a sorter cache works?
Why do you use Mapping Parameter and mapping variable?
