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
- 33069 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
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What are the different types of lookups in datastage?
What is the purpose of pivot stage and types of containers in datastage
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is datastage engine?
What are the functionalities of link collector?
What are the stages in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
What is the difference between account and directory options ?
how many rows sorted in sort stage by default in server jobs
What are the functionalities of link partitioner?
Where do the datastage jobs get stored?
What are some prerequisites for datastage?
Define project in datastage?
AGGREGATOR default datatype
