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


Please Help Members By Posting Answers For Below Questions

What is a merge?

684


what is use of SDR function?

4720


What are the different common services in datastage?

720


What are the differences between datastage and informatica?

585


Explain how a source file is populated?

779






How to convert RGB Value to Hexadecimal values in datastage?

3468


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

1798


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

2852


how to delete one row in target dataset

2597


What are the different type of jobs in datastage?

619


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

558


How do you remove duplicate values in datastage?

645


What are the functionalities of link collector?

639


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...

1094


What are the main features of datastage?

672