DSXchange

Hi, getting warnings at the time load data into oracle table. issue as index unusable state . Is there any approach to override this issue. OraWkdWorkRaw,0: ORA-39776 : fatal Direct Path API error loading table WORK_ODS OraWkdWorkRaw,0: ORA-26026 : unique index SYS_C00609384 initially in unusable st...

Multiply with 10,00,000 and convert from decimal to integer and check the value is zero. If Yes, populate "" else value. 1.if value 0000000000000000000.001000 then - final value as 0.001000 2.if value 0000000000000001000.000000 then - final value as 1000 3.if value 0000000000000000000.000...

Hi,

Decimal values from source getting as 00000000000000000000.000000(DECIMAL (26,6)).If it's value of integer part and also decimal part is 0(ZERO) then convert it as blank("").

Could you please let me know how to achieve this logic?

Regards,
Srini

Hi,

Date value coming from source as YYYYMMDD Varchar( 8 ).It's need to be convert as DD/MM/YYYY Varchar(10).Please let me know the function to be used for specified format.

Thanks,
Srini

Hi Guys,

Please need your help.
Does anyone here use Datastage with Netezza?
When I use Informatica 9.1.0 with Netezza, we would need the PowerExchange for Netezza license.
Please let me know if we use DataStage with Netezza, do we need any license.

Thanks,

Hi, Need to implement the below logic, it would of great help if you have any suggestions. 2 tables I got T1 and T2 with below values. T1 having 10 million rows and T2 having 5 million rows. T1 Table C1 Column name 1 1 2 3 4 4 5 6 T2 Table C1 Column name 1 3 6 7 Output Should be 2 4 5 Any ideas woul...

Hi, My job is as below design. ODBC Connect -> TPT Connector The job is getting aborted with the below Fatal error. Error reading record Job_NAME..fifo from file RT_SCTEMP - error number is 1. The job is a multi instance job. I have gone through the below forum, could not get much. http://www.dsxcha...

We intend to upgrade on the same machine.

Thanks, for the emails, will let you know the response from the client and IBM.

Thanks,

Hi Guys,

We are into DataStage 8.1, we need to migrate to DataStage 8.5.

Can you please let me know the steps to migrate to DataStage 8.5.

It would be of great help, any do or don'ts.

Thanks,

Thanks for the replies,

I have scheduled a job via DataStage Director with id SRINI.

How to find out where does it get stored in unix.

I tried doing crontab -l, it says no crontab for SRINI.

Any ideas or help would be appreciated.

Thanks,

Hi, We are using DataStage director 8.1, as a scheduler tool in our dev environment. 2 issues we are facing in the while scheduling. 1. Whenever we re-start the Linux Server, all the jobs from the scheduler get removed and we have to again re-schedule the jobs manually. 2. Sometimes the jobs Schedul...

We have been facing space issues in Dev environment, hence the requirement. "if you are sure that the dataset PX_BEA.ds will never be referenced you can go ahead and delete the segment files corresponding to PX_BEA.ds" 1 Question What happens if I delete BEA.ds.dsadmin.DEV.0000.0000.0000.6...

Thanks for the reply. In my case I got a requirement to delete dataset segments which has names such as PX_BEA.ds.dsadmin.DEV.0000.0000.0000.65e7.cf771bfe.0000.b324c6a7 located in is/node1/dataset. Without knowing dataset descriptor file exist or do not exist in the seperate path can I go ahead and ...

Hello, The descriptor file is generated in path /is/DEV/datasets/PX_BEA.ds The data file is generated in path is/node1/dataset i.,e BEA.ds.dsadmin.DEV.0000.0000.0000.65e7.cf771bfe.0000.b324c6a7 My Question 1. Can we go ahead and delete the data file without deleting the original descriptor file. 2. ...

Thanks for the replies guys,

BTW, What is causing the RT_LOGXXX issue and how to avoid this.

Thanks,