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

Suppose i have 10000 records.First time i have to load 1 to
1000 records and second run i have load 1000 to 2000
records and third load i have to load 2000 to 3000 rows .How
will achieve

Answer Posted / praveen

You can use override query in the source qualifier and set it to read rownum <= 10000. This will load the first, similar way you can do the remaining.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2032


What is domain and gateway node?

1122


Differences between version 7.x and 8.x.

1843


How to update source definition?

1033


What is the benefit of session partitioning?

1046


What is joiner change?

1079


generate date / time dimension in informatica

1073


Difference between Target-based loading and constraint-based loading?

947


What are the prerequisite tasks to achieve the session partition?

1180


What is lookup transformation?

1005


can any one give some examples for pre sql and post sql(Except dropping and creating index).

4039


What are mapplets? How is it different from a Reusable Transformation?

1034


What is the difference between informatics 7x and 8x and what is latest version?

1026


Differentiate between router and filter transformation?

954


How do you update the records with or without using update strategy?

1060