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

Different ways a project can be moved to production ?...example ….export-import and Version control.

2214


how to delete one row in target dataset

2861


Define Data Stage?

870


1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

1899


what is flow of project?

1766


what is repositery?

1570


What is the use of datastage director?

812


file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

739


how to export or import the jobs in .ISX file

968


What is ds designer?

865


How do you schedule or monitoring the job?

907


What are the areas of application?

929


What is the difference between the local container and shared container?

881


Can you explain kafka connector?

1051


How a routine is called in datastage job?

849