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
How a source file is populated?
Name the command line functions to import and export the DS jobs?
What are the steps required to kill the job in Datastage?
What are the different options associated with dsjob command?
Difference between server jobs & parallel jobs?
Differentiate between operational datastage (ods) and data warehouse?
What are the important features of datastage?
What steps should be taken to improve Datastage jobs?
What is the difference between the local container and shared container?
How can you write parallel routines in datastage PX?
how to implement scd2 in datastage 7.5 with lookup stage
What is the roundrobin collector?
What all the types of jobs you developed?
Which algorithm you used for your hashfile?
Can you define merge?