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 / divesh chasta

informatica solution :
first we will create seq and then filter out the third
record by this condition mod(id%3)=0

from this we can get third record.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the reusable transformations?

1220


How to use pmcmd utility command?

1077


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7235


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1141


what are the deliverables?in your project?

2194


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8263


How to differentiate between the active and passive transformations?

1229


Differentiate between Load Manager and DTM?

2213


What is an active transformation?

1159


Make a note of the quantity vaults made in informatica?

1043


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2254


What is native users?

1222


Does an informatica transformation support only aggregate expressions?

1086


How to update or delete the rows in a target, which do not have key fields?

1222


Which is the t/r that builts only single cache memory?

1238