DSXchange

kondeti wrote:Hello, Is it possible to replace OCI with DRS Stage? If So, try once.

I was using the Oracle Connector stage and the DBA's concluded that they don;t have any solution for that. I can replace some other stage too..but it that works means i need to change lot of job designs...

Hi, This error is coming repeatedly lots of other jobs started failed in the Production, and DBA's are trying to find out the issue. And more strange part is before any job fails first time if we restart the job they will work fine,but the new failed jobs are not running second also.It was spreading...

Hi, Thank you for all your support.Still My issue is not resolved: > SELECT SP.* > FROM TABLE1 SP > INNER JOIN ( > SELECT i.EMPID > , i.YEAR, > , MAX(i.EFF_END_DT) EFF_END_DT > FROM TABLE1 i > WHERE SRC='A' > GROUP BY i.EMPID, i.YEAR > ) C > ON SP.EMPID=C.EMPID > AND SP.YEAR=C.YEAR > AND SP.SRC=C.SR...

Do you have any idea what are the things i need to check with DBA's please let me know..

Hi , One of the job is failing in Production by giving the below error.. ORA-03113: end-of-file on communication channel If i re-run then it was running fine. I am getting the data from one table and loading it in to table using Oracle connector.Any one have any idea what was causing this issue.Plea...

Sorry for misleading Chulette. Thank you for the information.

Yes Chulett. Thank you for the reply.

I did the same, but i thought there might be the limitation in the Datastage,may be someone knows...how many lines it will allows normally do you have any idea...i am just curious to know..

Hi,
I have create one job which has about 150 lines of sql. So i tried using the Oracle Enterprise Stage and DRS Stage in 8.0.1 Version. It was not allowin after some line of sql. Can any one help me to solve this.Thank you.