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

A flatfile contains 200 records.I want to load first 50
records at first time running the job,second 50 records at
second time running and so on,how u can develop the job?pls
give the steps?pls pls

Answer Posted / sarath

i think using global parameter we can achieve this in transformer . first set the parameter value to 0 or 1 and finally after transforming set the parameter value to max(rownum) so that the value will b updated. for the next time using use that parameter as the starting point to load the data.

sorry if it is wrong.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How a source file is populated?

1111


Name the command line functions to import and export the DS jobs?

1199


What are the steps required to kill the job in Datastage?

1264


What are the different options associated with dsjob command?

1483


Difference between server jobs & parallel jobs?

1129


Differentiate between operational datastage (ods) and data warehouse?

1230


What are the important features of datastage?

1197


What steps should be taken to improve Datastage jobs?

1120


What is the difference between the local container and shared container?

1142


How can you write parallel routines in datastage PX?

1065


how to implement scd2 in datastage 7.5 with lookup stage

5663


What is the roundrobin collector?

1149


What all the types of jobs you developed?

1246


Which algorithm you used for your hashfile?

1230


Can you define merge?

1188