How to read multiple files at different directories using a
single Sequential File stage in DS Enterprise Edition
- 6 Answers
- 24523 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
If all files having same Metadata,
Select Read method as 'specific file(s)'
then u Can add as many files as you want to run by selecting 'file' property from the 'available properties to add'.
It locks like below:
File= /dsg/work/temp/Employee1.txt
File= /dsg/work/Employee2.txt
File= /dsg/Employee3.txt
Read Method= Specific file(s)
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / venkata ramana
To read given number of files, one can use follow below
In the sequential file stage, Use
Read Method =File Pattern
File Pattern=`ls /* | head -<Number of files to be read>`
For example, I had 5 files, with similar pattern (as
date*.txt), in working folder say "/data/working/". If we
want to read three files out of these five files, one can
use following command:
`ls /data/working/date*.txt | head -3`
Just modified Venkat's Answer based on tested job.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / satyam
sequential file stage in that option is available you can observe that, ok i will send how to process later ok
| Is This Answer Correct ? | 4 Yes | 5 No |
Answer / 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 |
Answer / venkat
To read given number of files, one can use follow below
steps:
1. In the sequential file stage, Use Read Method as
Specific File(s).
2. Now in the file text field, Put below command.
`ls /* | head -<Number of files to be read>`
This will read given number of files.
For example, I had 5 files, with similar pattern (as
date*.txt), in working folder say "/data/working/". If we
want to read three files out of these five files, one can
use following command:
`ls /data/working/date*.txt | head -3`
Hope this helps.
venkat
09940692102
| Is This Answer Correct ? | 0 Yes | 7 No |
Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
source contains 2 columns comes to target 4 columns how
What is ibm datastage?
How can we improve the performance in datastage?
How to Convert the columns into rows?
what is initial load and incremental load
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/
How to convert table data into xml file using xml output stage? please explain step by step;
Which type of joins Merge stage can support?
What is the difference between account and directory options ?
which memory is used by lookup and join
Teradata 
