Search found 186 matches
- Thu Dec 13, 2012 12:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle - data loading issues
- Replies: 1
- Views: 2699
Oracle - data loading issues
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...
- Mon Dec 03, 2012 5:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal value (00000000000000000000.000000) to blank it
- Replies: 6
- Views: 3761
Re: Decimal value (00000000000000000000.000000) to blank it
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...
- Mon Dec 03, 2012 3:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal value (00000000000000000000.000000) to blank it
- Replies: 6
- Views: 3761
Decimal value (00000000000000000000.000000) to blank it
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
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
- Thu Nov 15, 2012 11:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert String(YYYYMMDD) to String(DD/MM/YYYY)
- Replies: 1
- Views: 1756
Convert String(YYYYMMDD) to String(DD/MM/YYYY)
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
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
- Wed Sep 19, 2012 12:44 am
- Forum: General
- Topic: DataStage with Netezza
- Replies: 3
- Views: 3688
DataStage with Netezza
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,
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,
- Thu Jun 30, 2011 5:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Logic Help
- Replies: 5
- Views: 2596
Logic Help
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...
- Wed Jun 22, 2011 1:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: RT_SCTEMP - error number is 1
- Replies: 1
- Views: 1358
RT_SCTEMP - error number is 1
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...
- Tue Jun 07, 2011 5:15 am
- Forum: General
- Topic: Upgrade from DataStage 8.1 to 8.5
- Replies: 7
- Views: 7317
- Mon Jun 06, 2011 1:47 am
- Forum: General
- Topic: Upgrade from DataStage 8.1 to 8.5
- Replies: 7
- Views: 7317
Upgrade from DataStage 8.1 to 8.5
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,
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,
- Tue May 10, 2011 1:44 am
- Forum: General
- Topic: Director scheduling/Linux re-start issue
- Replies: 4
- Views: 2685
- Wed May 04, 2011 3:37 am
- Forum: General
- Topic: Director scheduling/Linux re-start issue
- Replies: 4
- Views: 2685
Director scheduling/Linux re-start issue
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...
- Wed Apr 20, 2011 7:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Deleting descriptor file
- Replies: 8
- Views: 5637
- Wed Apr 20, 2011 6:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Deleting descriptor file
- Replies: 8
- Views: 5637
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 ...
- Wed Apr 20, 2011 6:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Deleting descriptor file
- Replies: 8
- Views: 5637
Deleting descriptor file
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. ...
- Thu Apr 14, 2011 4:43 am
- Forum: General
- Topic: What are CT VOC and ED VOC
- Replies: 6
- Views: 3534