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

without table how to come first record only in oracle?

2255


What is decode in static cache?

1180


What are the types of data warehouses?

1526


In informatica workflow manager, how many repositories can be created?

1363


how to create user defined function (udf) in informatica

1307


What the difference is between a database, a data warehouse and a data mart?

1155


Define pmcmd command?

1047


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7391


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1628


What is the difference between informatica 7.0 and 8.0?

1016


What is target load order?

1247


Tell me about MD5 functions in informatica

929


How can we use mapping variables in informatica? Where do we use them?

1203


What are the differences between oltp and olap?

972


Why filter transformation is an active one?

987