DSXchange

Even in the grid env , you should be able to see the resource disk and resource scratchdisk on the dynamic configuration file from the director log. ensure that space is there on those paths.

Check the scratch disk and resource disk space - you shd get this in the config file. Ensure that enough space is there in these paths.

The ORACLE_HOME it set in dsenv. It is also there in .profile file of the unix user.

Hi I am facing an error in scheduling jobs through DataStage scheduler. When I schedule 'Today' and set a time , the ORACLE_HOME environment variable is set in the "Environment variable settings" when the job runs. If I use 'Every' and select some days and set a time, the ORACLE_HOME envir...

Thanks every one for the replies.

Just wanted to post the solution so that it could be useful to some one. I used record delimiter string='|\n' and it worked for both the header record and the data records.

Hi, I have a requirement to generate a | delimited file. The final delimter of the record also should be |. I specified the First line is column header to true. I set the record level final delimiter to |. I set the Field level delimiter to |. I am getting everything properly except the final delimi...

We have DataStage set up on the sun grid. We have a job that reads from a sequential file and loads into a database table. The input sequential file contains around 5 million records. We are observing a pattern in which the DS job stops reading after 1 million record. It does not abort or give any m...

Does the same job run with single node configuration file?

We also had a similar error and when we tried with a config file with less number of nodes it started working. Something to do with number of UNIX processes I think.

Use a hashed file selecting the keys as the columns based on which you want eliminate the dups.

Hi, We have been asked to use the key management routines (KeyMgtGetNextValue,KeyMgtGetNextValueConcurrent) of DS for surrogate key generation over Oracle sequences. And we are using parallel jobs. Is BASIC transformer the only way to call these routines? How much of an over head will it be to use B...

I am not sure if this is going to help you. But try to have two passive stages on either side of the link collector. For example join from two sequential files and write to a sequential file before taking to a transformer.

I think the conversion of # to ? has something to do with the default padding char in the file.

I believe you can do something like type c:\merge\*.txt > c:\merge\outfile.txt This you have to execute at the command prompt.

Hi, I have a data file which has the following layout. How do I read this in DS? 10|ASBT115072 25C4|05|50001670|01|05192003|1|4|EA 40|ASBT115072 25C4|05|50001670|01|SINGLE PHASE PAD TYPE 2 (line 1) 20|ASBT115072 25C4|05|50001670|01|0002||02005|CP05|5RTST|Ratio Test|1.000|EA|X|1|1|1.500|H|5.650|H|3.3...

hi, i have two files f1 and f2 which looks like this. f1 c1,c2, .. 100,1,.. 100,2,.. 100,3,.. 200,1,.. 200,2,.. 300,1,.. and f2 c1,c3,.. 100,1000,.. 100,2000,.. 300,1000,.. 300,2000,.. the output file should be c1,c2,c3, 100,1,1000,.. 100,2,2000,.. 100,3,NULL,.. 200,1,NULL,.. 200,2,NULL,.. 300,1,100...