Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How to read multiple files at different directories using a
single Sequential File stage in DS Enterprise Edition

Answers were Sorted based on User's Feedback



How to read multiple files at different directories using a single Sequential File stage in DS Ent..

Answer / subhash

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

How to read multiple files at different directories using a single Sequential File stage in DS Ent..

Answer / pvn

using file pattern

Is This Answer Correct ?    16 Yes 6 No

How to read multiple files at different directories using a single Sequential File stage in DS Ent..

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

How to read multiple files at different directories using a single Sequential File stage in DS Ent..

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

How to read multiple files at different directories using a single Sequential File stage in DS Ent..

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

How to read multiple files at different directories using a single Sequential File stage in DS Ent..

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

Post New Answer

More Data Stage Interview Questions

what is flow of project?

0 Answers   HSBC, IBM,


I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know

6 Answers  


If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

5 Answers   Infotech,


What is difference between server jobs & parallel jobs?

0 Answers  


create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid   salary   previoussalary 10      1000     null 20      2000     1000 30      3000     2000       40      4000     3000

5 Answers   Genpact,


when we have to go for a sequential file stage & for a dataset in datastage?

1 Answers  


What are routines in datastage? Enlist various types of routines.

0 Answers  


What are the steps required to kill the job in Datastage?

0 Answers  


Wat is isolation level and when do u use them?

1 Answers   HP, IBM,


How to RD using transformer?

0 Answers   CTS,


How many types of sorting methods are available in datastage?

0 Answers  


my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

3 Answers   TCS,


Categories