DSXchange

My requirement is to download the CSV file from sharepoint and load the data from the CSV file to Oracle.

Please let me know if anybody have worked with files on sharepoint.

Vishvas

Hi,

Do we have any unit testing framework (like nunit) available for DataStage? Also is there any way one can find out the code coverage percentage while performing unit testing?

Regards,
Arun

Hi, We are using CDC in our job. For that we use current dataset and history dataset as inputs. At the end of the job we create one more dataset which will act as hist dataset in the next run. We data is hash partitioned on the KEYS in both datasets. The job works fine if the history dataset is crea...

Hi, Is there any way to parametrize the PX routine path? The problem is if we move the routine from one environment to other environment then we have to change the path accordingly. One way is to create the same folder structure in both the environments. But due to unavoidable reasons if the folder ...

I have a file with 3 columns. My requirement is to check each column for 3 quality dimentions namely Completeness, Format and Values. My plan is to create common Rule defns for all three quality dimentions and create one Rule per column per quality dimention. So there will be 9 Rules and 3 Rule Defn...

Hi, I have a job that reads data from sequential file. I have a reject link attached to the sequential file stage. If there is any mismatch in the datatype, then the record will be passed to the reject link and there will be a warning in the log. My requirement is not to create the warning in the lo...

No, Datastage Director doesn't reflect the changes to the timings made at the backend. It takes the details from RT_CONFIGnnn file for displaying. But if you delete a schedule from backend, that will be reflected in the Director.

The only issue is that it won't be reflected in the director. The director will show a different schedule and the job will run at different schedule.

We have more than 30 schedules in our project. In case of any downtime we haev to reschedule all the 30 schedules manually. This is time consuming and error prone. So I was thinking of some solution where we can have the schedules in a excel and a job will read the excel and change the schedules acc...

Hi, We are planing to migrate our jobs from 7.5 to 8.1. We have been testing some of our jobs in 8.1. One of our job uses DS_METADATA table. We access that to read the contents of a table defn. In 8.1 I tried to access that table. The table exists but does not contain any data. I think all the data ...

Sorry I didn't mention about the users. All the five projects are started with different unix users and each user has the process limit of 8000. So its not a problem with the max no of process/user. Also DS server runs on a 16 CPU HP box. Is there any limitation that the number of instance of a sing...

We have 5 projects under one server. There are 7 jobs that are common for all the projects. These are multi instance jobs. They are designed in such a way that one calls the other in sequence. We have around 10 streams (i.e. 10 instances) in each project. So each of those 7 jobs will be triggered fo...

We are getting a UVSH core dump. But the phantom process still remains and we are able to stop the job using dsjob API. Only one <defunct> process is associated with the phantom process of that job. How is the UVSH and phantom process related. When will the UVSH will creat core dump. Thanks, Arun

We had the same problem. We could not login into the director or start any jobs. We stoped some of the jobs that were running and everything became normal.

Regards,
Vishvas

Hi, Is there any process limit in DS? I have five projects running on the same DS server. Each project has 100 jobs running in parallel. We used to get unhandelled exception (controller problem - could not start a job). It will go fine the next time. But this problem aggravated this week end as none...