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
- 7 Answers
- 33329 Views
- TCS, I also Faced
- E-Mail Answers
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 is orabulk stage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
On which interface you will be working as a developer?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Notification Activity
What are stage variables, derivations and constants?
What is the difference between datastage and datastage tx?
Differentiate between data file and descriptor file?
options available in sequence job to run,validate?
What are the areas of application?
Triggers,VIEW,Procedures
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
How can we improve the performance in datastage?
What is use Array size in datastage
