Search found 79 matches

by suresh.narasimha
Mon Feb 08, 2016 4:59 pm
Forum:
Topic: Workbench metadata export from Oracle
Replies: 8
Views: 5504

I have raised a PMR with IBM for resolution. If you have any suggestions that could help resolve my issue, please let me know

Regards
by suresh.narasimha
Thu Feb 04, 2016 6:12 pm
Forum:
Topic: Workbench metadata export from Oracle
Replies: 8
Views: 5504

Sorry, I didn't understand what you want me to do, earlier.

Now I tried Connector Import Wizard and I couldn't see "MDM Connector" in the list.

Does this mean something missing ?

Thanks
Suresh
by suresh.narasimha
Thu Feb 04, 2016 5:36 pm
Forum:
Topic: Workbench metadata export from Oracle
Replies: 8
Views: 5504

What is your goal? My end goal is to write data into MDM database using MDM connector stage. To do that I'm first exporting MDM metadata from MDM Workbench as XMI files. Then I would import these XMI files into Infosphere Metadata Asset Manager and share it in XMETA database, so that I can see that...
by suresh.narasimha
Thu Feb 04, 2016 4:59 pm
Forum:
Topic: Workbench metadata export from Oracle
Replies: 8
Views: 5504

metadata import using MDM Workbench

Yes, I'm able to import metadata using DataStage plugin import.

Regards
by suresh.narasimha
Wed Feb 03, 2016 8:53 pm
Forum:
Topic: Workbench metadata export from Oracle
Replies: 8
Views: 5504

Workbench metadata export from Oracle

Hi I'm not able to export metadata from Oracle database using Metadata Workbench. I'm using this application for first time with and I'm learning and doing it at the same time. What i did so far --> 1 Using Rational Application Developer (Workbench), created a Configuration Project. 2 Then launched ...
by suresh.narasimha
Mon Jun 10, 2013 3:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Truncate and Round Float type data
Replies: 3
Views: 2386

Float data type trunc and round

Hi Chulett Here is some sample data input and desirable output Input Output (8 decimals) ===== ========== 0 0.00000000 - Padded with zeroes 1.22334222765 1.22334223 - Truncate and Round 1.23244 1.23244000 - Truncate and Round Thanks
by suresh.narasimha
Mon Jun 10, 2013 12:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Truncate and Round Float type data
Replies: 3
Views: 2386

Truncate and Round Float type data

Hi I have a Sybase source with Column A as Float. I want to Truncate the value of decimals to 8 places and round it and if there is a zero after decimal place, that should be padded with 8 zeroes. My job design is Sybase Src (Float) ---> Transfrmer ----> Sequential file (Float) I didn't find a funct...
by suresh.narasimha
Tue Jul 17, 2012 1:17 am
Forum: General
Topic: Decrypting issue with GPG
Replies: 4
Views: 3341

Thanks All for your responses. I'm not sure about the resolution of this issue. It was resolved automatically. Now I'm able to decrypt all files. I didn't do any changes at all. @Chulett : I have posted the issue in GPG forum, but it's already a month now, I didn't receive any suggestions. Have a gr...
by suresh.narasimha
Thu Jul 12, 2012 7:06 pm
Forum: General
Topic: Decrypting issue with GPG
Replies: 4
Views: 3341

Decrypting issue with GPG

Hi I'm facing some issues with decrypting files using GPG4Win 2.1.0 I have an execute command activity that triggers a windows batch file in server. some error messages listed below, ************************ Decryptnavtech..JobControl (@Execute_Command_0): Executed: E:\Data\Engineering-Test\Scripts\...
by suresh.narasimha
Tue Aug 02, 2011 12:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DB2 error when I run the job
Replies: 3
Views: 4658

DB2 error when I run the job

Hi,

I have searched google and found the link that you have posted, but I wanted to make sure before I go to the DBA and ask him to enable the stored proc.

the issue has been resolved, stored procedure was not enabled due to some upgrade in db2 database.

Thanks for yor help.
by suresh.narasimha
Tue Jul 26, 2011 2:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DB2 error when I run the job
Replies: 3
Views: 4658

DB2 error when I run the job

Hello My job aborted with a DB2 message " [IBM][CLI Driver][DB2] SQL0471N Invocation of routine "SYSIBM.SQLTABLES" failed due to reason "00E7900C". SQLSTATE=55023 " I have searched forum, but could not find appropriate post. Regarding my job, I'm using a db2 stage and w...
by suresh.narasimha
Mon Jun 07, 2010 11:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Auto purge options
Replies: 5
Views: 2643

Auto purge options

Hi I wanted to know that if we select the auto purge option to purge to previous number of job runs in admin client, will the multi instant job status records in director delete to certain number mentioned. i.e will some of the instances delete from the status view in director.(datastage 8.1 server ...
by suresh.narasimha
Thu Feb 11, 2010 1:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Automate Converting OCI 8 to OCI 9
Replies: 3
Views: 3428

Automate Converting OCI 8 to OCI 9

Hi All There is a need to convert all the OCI 8 stages in a project to OCI 9. The process we followed was, exported a job in XML format and replaced the Stage Type from "ORACI8" to "ORACI9" and the code worked. Is there a better way to convert the stages?? Like any command from A...
by suresh.narasimha
Thu Feb 19, 2009 1:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot open file DSR_JOBS
Replies: 1
Views: 2527

Cannot open file DSR_JOBS

Hi All Today I had a problem while I try to export components. Error calling subroutine: *DataStage*DSR_SELECT (Action=7); check DataStage is set up correctly in project glreports_uat (Subroutine failed to complete successfully (30107)) So, I rebuilt the DataStage Reporsitory indices. Now after the ...
by suresh.narasimha
Tue Jan 27, 2009 9:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC configuration
Replies: 2
Views: 3998

ODBC configuration

Hi All Im using an ODBC stage to pull data. But when i try using that its not resolving connection. Errored out with below message. DSR.MetaGeta(GET.DSNINFO)(SQLConnect('pscrm3g','sysadm')): BCI Error: SQLSTATE=08001,CODE=-1,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver]...