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 informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?

Answer Posted / anoymous

override source qualifier

select * from tablename where rownum=1 and rownum=10;

Is This Answer Correct ?    4 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how many types of dimensions are available in informatica?

1073


What is the use of target designer?

1024


What are the performance considerations when working with aggregator transformation?

1133


What is meant by active and passive transformation?

1111


How can repository reports be accessed without sql or other transformations?

1203


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

1166


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)

1609


Explain what is informatica metadata and where is it stored?

1035


What is sorter transformation?

1027


What is a node in Informatica?

1027


How to update source definition?

1076


What are the new features of informatica 9.x at the developer level?

1029


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2729


To import the flat file definition into the designer where should the flat file be placed?

1043


What are the types of presistent cache in look up tr.

2044