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
- 9117 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / arpan
Select empid,monthyear,sal from empsal
where sal>100000
orderby monthyear;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is incremental aggregation?
What is dynamic cache?
Write the advantages of partitioning a session?
What is meant by incremental aggregation?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is rank transform?
Explain sessions?
How can we use batches?
What are the types of data warehouses?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Can we create two repositories on same database instance in oracle?
Explain the shared cache and re-cache?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is a grid in Informatica?
What are multi-group transformations?
