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...

In a table, 4 person having same salary. How to get Third
person record only?

Answer Posted / rag

We can do this by adding the rownum pesudo coulmn in the sql
overrider and take the thrid one since all the values are same,

like select col1,col2,rownum
from tab1
where rownum=3

Is This Answer Correct ?    1 Yes 21 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is informatica etl tool?

1003


how to create user defined function (udf) in informatica

1315


Explain how to import oracle sequence into informatica?

1021


What do you mean by blocking transformation?

1052


How to differentiate between the active and passive transformations?

1171


How you prepared reports for OLAP?

1599


What is xml source qualifier transformation in informatica?

1225


wf dont have integration severances how you can run?

1942


What is Cognos script editor?

4240


What are the transformations that are not supported in mapplet?

1034


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2078


According to his methodology what all you need before you build a datawarehouse

1761


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1669


what are 3 tech challenges/ common issues you face?

2349


What is InformaticaPowerCenter?

1139