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
How to RD using transformer?
What all are the different way to run a job?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are data elements?
What are stage variables and constants?
What are the steps needed to create a simple basic datastage job?
Define ds designer?
Can you explain link buffering?
Explain ibm infosphere information server and highlight its main features?
What is the different type of jobs in datastage?
what is flow of project?
How to Remove Duplicate using SQL?
How to perform incremental load in datastage?
explain about citrix scheduling tool in datastage