DSXchange

Thanks Ray. The situation we are in is... the number of dataset files are not fixed. We are in the pilot and as we mass... we may get more dataset files as input. We cannot afford to open up the code to add the new dataset stage, everytime. That was the reason, why I was exploring the pattern read f...

They are datasets. We are planning to move from sequential files to Datasets for obvious performance reasons. Any help is greatly appreciated.

Yes they are exactly identical in layout. How do you use the file set?

I have a need for reading multiple files with the similar structure in one dataset stage? Since I can't specifiy a pattern in the DataSet stage, how would I achieve this? For example, I have 4 file like Item_A.DS, Item_B.DS, Item_C.DS and Item_D.ds (all with similar column layouts). I have to read-i...

Hi All, I have a UNIX script calling a datastage sequence with some parameters from the UNIX script. The sequence calls a datastage job that fetches the data from Teradata database. Following is the requirements: If parameter A is passed from the UNIX script to the sequence, the datastage job called...

Hi All, What is the most optimum way of splitting one input into 3 output files based on the filed in the input. Input is being read from the Teradata table and the output should go into 3 different files based on the value in one column of the input data that is read from Teradata. Thanks in advanc...

You are wonderful!!!

That did it.

Thanks

Hello, We have a need to execute the same sequence by two jobs at the same time. I have checked the option of "allow multiple instance" on the sequence. But, when I execute the sequence through UNIX script, I get a failure message saying that the sequence is already running. Please assist....