DSXchange

Any other thoughts? Appreciate your response. I did search on the error 'TNS:could not resolve the connect identifier specified' in the forum and made sure the below are file. 1. tnsnames.ora has the valid service name 2. Configured ORACLE_HOME and PATH variables to oracle client installation 3. Use...

Hi Ray,

Yes, tnsnames.ora is configured properly and and I can connect to that service name using sql client.

Thanks

Hi Experts, We've done the following to access Oracle database using DRS stage. 1. Installed Oracle client 2. Made sure ORACLE_HOME and PATH variables are set properly in System properties > Environment variables. 3. Open DRS stage properties and hard coded connection name, user details to access da...

Hi Chulet,

The import/export process taking lot of time to complete.

Thank you.

Hi, We are experiencing significant time delays during DSX imports and exports (from six hours to several days). We have looked at a variety of things (ie - network, antivirus programs, installing client locally on the server, etc.), but these have either proven to not impact the processes, or any m...

Hi,

We want to track any changes to jobs made by the users.

In Datastage is there a mechanism which will audit changes made by the users to the jobs?

Please suggest me.

Thank you.

Hi, We have created a secondary group DSNOLOGIN, changed primary group of all the users under this secondary group to 'psoft' ( As per DS admin guide The primary group must stay the same as for the administrative user, 'psoft' is the primary group of dsadm) and assigned Datastage <None> role in Data...

Hi, One of the ETL jobs was in a running state & not changed to "Finished" state even after completion of job. Due to this the job was not compiled in the batch & when it was triggered by the scheduler the batch job had failed. Please suggest me what might be the reason caused this...

Thank you Chulett and Andy Sorrell.

I'll check the &PH& entries and let you know the exact messages.

Thank you for your suggestion.

Hi,

It is a simple job which reads the data from a source DRS stage and write to target DRS stage.

Source DRS stage --> CRC logic --> Target DRS stage.

Ascential DRS 7.5 - phantom processes are not exiting after a job has completed. These process can only be killed manually on UNIX using a "kill" command. As per my knowledge these phantom processes should be exited as the job finishes. Please help me out in this regard. Thanks in advance.

Hi Rey, I am sorry, it is version 7x. This is actually a incremental loading job using the CRC logic. IPC_out is a Inter-process stage. The job mainly have Source DRS stage, IPC_in, CRC logic (row merge, Transformer and row split stages), IPC_out and target DRS stage. JOb is running fine till the IP...

Hi, One of our OWS job is hanging at IPC_out (IPC out stage) stage. Even after 10, 12 hrs IPC out stage is not writing a single row to the Target table. I've tried with different set of IPC paramter values (AZ, TZ and turned on the row buffering option) but nothing is worked out. Please help me out ...

Hi, In my job, I have a DRS stage which picks the rows from table A in the source system. When I query the table A using sql plus, I got around 525 rows. But I am not able to view data from DRS stage and run the job it is taking more than 5,6 hrs without returning any rows. I am using same default u...

Hi, One of DRS stage is using a user-defined query as shown below. When I ran the job, its not throwing any error message and I am able to run the job successfully. But the above said DRSstage is not listing any rows. I am very curious to know how this user-defined query works. Actually in the WHERE...