How to read multiple files at different directories using a
single Sequential File stage in DS Enterprise Edition
Answer Posted / pooja
To read multiple files in a sequential file follow the
below process..
1. Enable "Allow Multiple Instances" in the Job Properties.
2. Add a job parameter in the sequential file stage where
the input file needs to be defined.
3. Compile and execute the job.
4. During execution, a value needs to be passed to the job
parameter..here pass the input file path placed in
different directories.
5. Execute the job for all the multiple files using the
same job by passing the input file path for each run.
6. An invocation id needs to be provided for each run. This
id indicates the no. of times the job has been executed.
Can be observed in the log.
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
what is the use of skid in reporting?
Define Merge?
What is aggtorec restructure operator?
What is the difference between validated and compiled in the datastage?
What is the command line function to import and export the ds jobs?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Lookup constraints
What are the functionalities of link partitioner?
Name the different types of Lookups in Datastage?
Can you define merge?
How can you write parallel routines in datastage PX?
What is ibm datastage?
What are routines in datastage? Enlist various types of routines.
options available in sequence job to run,validate?