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
What are routines in datastage?
What are the processing stages?
Can you explain engine tier in information server?
What are transforms and what is the differenece between routines and transforms?
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...
What is use Array size in datastage
What is the difference between passive stage and active stage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What all are the different way to run a job?
How rejected rows are managed in datastage?
What is the purpose of pivot stage?
What is meta stage?
what is the difference between == and eq in UNIX shell scripting?
What is the purpose of interprocessor stage in server jobs?
Notification Activity