Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answer Posted / gd

select empid,monthyear from empsal where sal>100000;

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2263


What are the different types of transformation available in informatica.

1080


How to configure mapping in informatica?

1158


How to generate sequence numbers without using the sequence generator transformation?

1177


Can you use flat files in Mapplets.

2639


differences between service based and product based?

1993


What is a filter transformation and why it is an active one?

960


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4711


In warehouses how many schemas are there?

1056


Do you find any difficulty while working with flat files as source and target?

1080


hi real timers . iam waiting for ur reply regarding ETL TESTING

2254


Differentiate between reusable transformation and mapplet.

1069


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.

1677


What is confirmed fact in dataware housing?

6924


What are the different versions of informatica?

1243