DSXchange

Thanks for all of your responses.

As "velagapudi_k" suggested, i could add job from the repository and could set all properties.

Anyway i would raise a ticket to Vendor and let us see what response i get and i would let you all know.

Regards
Elavenil

Hi DSGuru2B, Thanks for your response. I clicked on the plus sign but nothing happens. It shows only the category but not the jobs. And all the jobs in the category only. I have only 2 categories and it did not show the jobs from both categories. Can you guys enlighten me if this is a bug!! Regards ...

Am using 7.5x2 version, there are 3 job activity connected from sequencer activity in the job sequence to run all 3 jobs at same time. Then am trying to attach a job but the job list did not show any job at all. When i double clicked on job activity the dialog box appears and then try to select the ...

Suresh,

If that is the req, as Narasimha highlighted there is no difference between the source & target. The first row can be sent to the output from the aggregator and source file itself can be shown as reject records.

Regards
Elavenil

This is resolved. The incorrect path was mentioned in dsenv file.

Thanks for your responses.

Regards
Elavenil.

Yes Craig. I did that.

Due to security standards, we are planning to use ODBC for extraction and Oracle Enterprise Stage for target load if ODBC performance is acceptable by the customer.

Regards
Elavenil

Hi Craig, Thanks for your response. There is no branded_odbc in the PXEngine folder, which is the value of APT_ORCHHOME env variable. I have added $DSHOME/branded_odbc in the path env variable and $APT_ORCHHOME/lib & $DSHOME/branded_odbc/lib in the library path env variable. In ODBC INI, i have ...

We are trying to use ODBC enterprise stage to extract data from Oracle databases. I have done changes in dsenv, .odbc.ini and uvodbc.config to configure Oracle database. When i try using ODBC stage, it gives me an error message as below. ##E TOSH 000205 19:10:55(005) <main_program> PATH search failu...

Yes. We have convinced the DBA team to provide the mentioned privileges in my earlier email.

Thanks for your responses.

Regards
Elavenil

Thanks Ray for your response.

Based on the objects i could guess that it reads available indices, partitions, data segments etc. before loading data into Oracle DB, and i explained this to the team and team is still requesting the info from vendor.

Regards
Elavenil

Yes Craig. They require specific info regarding those privileges and we requested the vendor to provide those info.

Thanks & Regards
Elavenil

Thanks Craig.

I had explained the same thing to DBA team over here but they were insisting us to provide the valid reason to have this privilege.

Let me talk to them again to get the privileges.

Regards
Saravanan

We are trying to configure the Oracle databases from ETL server. We are following the steps mentioned in the documentation, which is install & upgrade guide, to configure Oracle databases and it is being mentioned that the select privileges required some of the DBA objects like DBA_EXTENTS, DBA_...

Hi, We are in the process of setting up the development server with DataStage EE on unix. We need to connect to multiple RDBMS (Oracle, SQL Server, etc.,) as our source systems are in multiple RDBMS databases. 1. I have installed Oracle & MS SQL server client in the ETL server. 2. Made entries o...

Hi, We have installed DataStage EE on HP Unix machine, which has 8 GB ram and 4 CPU. After successful installation, tried configuring shared memory using shmtest to find out the recommended shared memory parameters. But the command failed with the following error message. Attaching to segments Dshmp...