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

What are routines in datastage?

1269


What are the processing stages?

1041


Can you explain engine tier in information server?

1063


What are transforms and what is the differenece between routines and transforms?

1003


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4140


What is use Array size in datastage

1721


What is the difference between passive stage and active stage?

1412


Difference between ‘validated ok’ and ‘compiled’ in data stage?

1197


What all are the different way to run a job?

1030


How rejected rows are managed in datastage?

1449


What is the purpose of pivot stage?

1100


What is meta stage?

1131


what is the difference between == and eq in UNIX shell scripting?

1422


What is the purpose of interprocessor stage in server jobs?

2171


Notification Activity

1350