How to read multiple files at different directories using a
single Sequential File stage in DS Enterprise Edition
Answer Posted / 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 |
Post New Answer View All Answers
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What are the enhancements made in datastage 7.5 compare with 7.0?
Differentiate between data file and descriptor file?
How many Key we can define in remove duplicate stage?
Where do the datastage jobs get stored?
How you Implemented SCD Type 1 & Type 2 in your project?
what is ds administrator used for?
Describe link sort?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What are the features of datastage flow designer?
Explain entity, attribute and relationship in datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Where do you see different stages in the designer?
What is the difference between in process and inter process?