DSXchange

Hello David, Following are the information you needed, tnsnames.ora ------------- BIT1_TST.XX.XXX = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS)(HOST = XX.XX.XXX)(PORT = 2484)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = bit1_tst.XX.XXX) ) ) SqlNet.ora ------------ # SQLNET...

The Oracle environment in Unix? Its set in your dsenv file. Its all documented in the readme, but you need to add two things to the dsenv file and then bounce DataStage: Your $ORACLE_HOME environment variable. Add $ORACLE_HOME/lib to your current $LIBRARY_PATH. Note that the exact name of the librar...

To be honest, I have never connected to Oracle using TCP with SSL. To help any further, Id need to see: * tnsnames.ora * sqlnet.ora * listener.ora and the actual Oracle error message as reported in the DataStage log. Did you remember to restart the listener (or at least tell it to reinitialise) afte...

Thanks David, Since Oracle 9i and Datastage resides in the same box i did change both tnsnames.ora and listner.ora. But still it does not work. Shiv >From: David Barham >Reply-To: >To: "datastage-users@oliver.com" >Subject: RE: Secure ODBC and OCI in Oracle 9i >Date: Fri, 2 May 2003 15:23:59 +1000 >...

Try changing the port number in TNSNAMES.ORA, if that is how you resolve Oracle names. -----Original Message----- From: Shivprasad Rao [mailto:shiv_rao@hotmail.com] Sent: Friday, 2 May 2003 0:27 To: datastage-users@oliver.com Subject: Secure ODBC and OCI in Oracle 9i Hello All, Secure ODBC feature o...

Recommendations to assist in making a smooth transition, in no specific order. - Backup ALL your Projects. - Backup ALL your Projects. Yes, I repeated this on purpose as it is REALLLLLLY important. - If using Version Control, now is a perfect time to clean it out and start fresh. - By clean out and ...

Hi All, I am in the process of planning an upgrade of DataStage and would like input from people on the list. Is anyone running version 6.0 of DataStage on HP-UX 11i in production? If so, how long have you been running it? What problems did you have or are having with running and installation? Regar...

My last client when live on DataStage 6.0 back in January of this year. They have not reported any major issues. The added functionality is well worth it. Is yours a fresh install? My client upgraded from 5.1 to 6.0. No major issues. Tim -----Original Message----- From: Phil Walker [mailto:philw@gno...

Id be curious as to what you are upgrading *from*. How old is the version you are currently running? That could effect some of the advise you get. -craig "Phil Walker" 04/30/2003 01:08 PM Please respond to To cc Subject DataStage 6.0 on HP-UX 11i Hi All, I am in the process of planning an upgrade of...

What is your current DS version ? I recently upgraded my AIX DS421r8 to DS6.0r3. We use a lot of Oracle sources/targets and ODBC to Teradata. -Doug -----Original Message----- From: Phil Walker [mailto:philw@gnosys.co.nz] Sent: Wednesday, April 30, 2003 2:08 PM To: datastage-users@oliver.com Subject:...

Malathi, The reason that I ask for expectations it that QA is pretty broad. What do you want to QA: 1. Development Techniques and Coding 2. Performance 3. Meta Data 4. The Data (Data Quality, Measures and Facts, Master Dimension Data, etc.) 5. Are you trying to tie back to source systems, financial ...

Tim, Our QA department does not expect more than what we are giving them now. I would like to check how rest of the world is getting their DataStage jobs tested by their QA departments (If it is different from what we are doing). Based on others input I would like to see how our QA testing could be ...

Malathi, What is the QA departments expectation of DataStage? You can customize the QA around their expectations. 1. Do they want to see mappings 2. Do they want to see transformation (code or English) 3. Are they looking for operational processing statistics? 4. Are they looking at Data Quality rep...

Hi, Could you share how your QA department handles testing DataStage Jobs, If it is different from what we do. What we do is: We have been giving source, target and transformation matrix (Lineage report) to QA department. QA department uses this lineage report to make sure that ETL is functioning as...

Chris I would like a copy of that macro. I should have VB code next week to update Access directly with the sequences. Thanks Kim. Chris Roberts wrote:I have a VISIO macro that reads the doc_tools.mdb and builds Project/Category/JobName documents. I would like to document the Job Sequences by Projec...