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


Please Help Members By Posting Answers For Below Questions

How to RD using transformer?

1121


What all are the different way to run a job?

846


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2932


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)

2512


What are data elements?

876


What are stage variables and constants?

924


What are the steps needed to create a simple basic datastage job?

890


Define ds designer?

1008


Can you explain link buffering?

936


Explain ibm infosphere information server and highlight its main features?

849


What is the different type of jobs in datastage?

737


what is flow of project?

1752


How to Remove Duplicate using SQL?

1069


How to perform incremental load in datastage?

915


explain about citrix scheduling tool in datastage

2078