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
- 33335 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / subhash
other than VARUN solution
1. Add 'row number' column in Seq File stage, so that each record has a number associated with it.
2. Add a job param with which we can provide the number of record from where we want to run the job. We can pass this either using Sequence Start LOOP(List type variables-50,100,150,200) or by shell script.
3. In the tfm, use a stage variable to run only from the record number till 50 records by counting each record.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can you highlight the main features of ibm infosphere information server?
What is the difference between the local container and shared container?
explain about citrix scheduling tool in datastage
Triggers,VIEW,Procedures
options available in sequence job to run,validate?
How do y read Sequential file from job control?
What are routines in datastage?
whom do you report?
What are sequencers?
What are the types of containers?
How a server job can be converted to a parallel job?
What are the types of hashed files in data stage
Why fact table is in normal form?
On which interface you will be working as a developer?
Define ds designer?
