How to read multiple files at different directories using a
single Sequential File stage in DS Enterprise Edition
Answer Posted / 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 |
Post New Answer View All Answers
What are the functionalities of link partitioner and link collector?
Which commands are used to import and export the datastage jobs?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are system variables and sequencers in datastage
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
How can you write parallel routines in datastage PX?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
If you want to use a same piece of code in different jobs, how will you achieve this?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is a merge in datastage?
Nls stands for what in datastage?
How to reverse the string using SQL?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Different ways a project can be moved to production ?...example ….export-import and Version control.