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

Describe the main features of datastage?

858


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

1869


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2187


Distinguish between informatica & datastage. Which one would you choose and why?

765


What is ds designer?

853


Can you explain kafka connector?

1025


What are the types of views in datastage director?

1535


Nls stands for what in datastage?

958


What is a merge?

861


How many types of sorting methods are available in datastage?

843


What is the difference between account and directory options ?

882


Why do we use link partitioner and link collector in datastage?

906


How can you write parallel routines in datastage PX?

821


Could anyone give brief explanation bout datastage admin

2167


Which commands are used to import and export the datastage jobs?

1166