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
- 33684 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
What is the project in datastage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
How to implement complex jobs in data stage?
How can one find bugs in job sequence?
What are the important features of datastage?
sed,awk,head
Describe stream connector?
What are the different options associated with dsjob command?
How you Implemented SCD Type 1 & Type 2 in your project?
What is the sortmerge collector?
how to abort the job its matain duplicates?
Why we use surrogate key?
How we can covert server job to a parallel job?
How do you generate sequence number in datastage?
What are the types of containers in datastage?
