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
What is a merge?
what is use of SDR function?
What are the different common services in datastage?
What are the differences between datastage and informatica?
Explain how a source file is populated?
How to convert RGB Value to Hexadecimal values in datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
how to delete one row in target dataset
What are the different type of jobs in datastage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
How do you remove duplicate values in datastage?
What are the functionalities of link collector?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What are the main features of datastage?