DSXchange

Sorry for the delayed response ...again Based on my last email ALL VALUES INSIDE TABLE Columns are: Value, Frequency, MAgree, MPart, mprob, uprob, type, Agree weight, Disagree weight JOHN 1 0 0 0.90 0.33 D 1.43 -2.73 JOHNATHAN 1 0 0 0.90 0.33 D 1.43 -2.73 JON 1 0 0 0.90 0.33 D 1.43 -2.73 I think I g...

My basic question in my quest to understand the quality stage functionality is How can I make these three records as matches. Jon smith seems to fall out of the loop when I run my unduplicate job with match specification set to 0 for clerical and matches Also what does it mean when one says this rec...

Hi Ray Unduplicate_Match_2,0: Variable: PrimaryName_USNA New MISSING weight for ALL values: 0.00 ALL VALUES INSIDE TABLE Columns are: Value, Frequency, MAgree, MPart, mprob, uprob, type, Agree weight, Disagree weight SMITH 3 0 0 1.00 1.00 D 0.01 0.00 Variable: Zip New MISSING weight for ALL values: ...

Sorry for my delayed response. Could not get time to work on my simple sample to understand as we had other production issues. Anyways I have since played a little bit with the data values and I still have questions Initially I had my cutoff values set at 25 for clerical and Match and it said no mat...

Hi All I am trying to understand how to he match specifications work My sample data file has 3 rows John Smith,83713 Johnathan Smith, 83713 Jon Smith, 83713 My objective is to make one of them survice as they are duplicates with different name I ran standardization on these using USNAME and USAREA r...

I have the following in my PXENGINE/lib folder

orchoracle.o -> /usr/IBM/InformationServer/Server/DSComponents/bin/orchoracle9i.o
drwxr-xr-x 2 dsadm dstage 4096 Jul 28 14:03 .
$ pwd
/usr/IBM/InformationServer/Server/PXEngine/lib

Here is another question


I have theoracle 9i client driver installed.

But I am accessing a 8i database.

It works using sqlplus so I am assuming the tool will be ok as well

Arvind

Thanks I am assuming a "No" means I do not need to define the ORACLE_SID environment variable The modules it was complaining about are avaiabable as shown below $ pwd /oracle/product/v920/lib32 $ ls -altr libcln* -rw-r--r-- 1 oracle dba 12993753 Jul 01 12:47 libclntsh.a -rw-r--r-- 1 oracle...

Is ORACLE_SID mandatory environment variable to be defined


In my dsenv I do not define the variable.

As per our DBA since the oracle host is not on the same host as datastage it is not required to define that


Arvind

After the install I now get this message when I try to import a metadata ##I IIS-DSEE-TUTL-00031 13:54:38(001) <main_program> The open files limit is 2000; raising to 2147483647. ##E IIS-DSEE-TCDB-00004 13:54:38(002) <main_program> Unable to access database oracleLibrary orchoracle could not be load...

Thanks What does the install.liborchoracle install? I am finding that above install file under /usr/IBM/InformationServer/Server/DSComponents When i run it i get the following permissions error $ ./install.liborchoracle Installing Oracle driver. Setting PX_DBCONNECTHOME variable for PXOperators You ...

This is the output of my ls -l *or* from PXEngine/lib folder lrwxrwxrwx 1 root system 11 Dec 07 2007 liborchstatsaix3.so -> orchstats.o lrwxrwxrwx 1 root system 10 Dec 07 2007 liborchsortaix3.so -> orchsort.o lrwxrwxrwx 1 root system 12 Dec 07 2007 liborchsasop9aix3.so -> orchsasop9.o lrwxrwxrwx 1 r...

Hi I need some help in setting my access to Oracle. We are unix based shop and we have version 8.0.1 running on AIX 5.3 On the unix host the oracle client is installed and I can connect to oracle using sqlplus. In dsenv file I have the following entries ### Oracle Environment Variables ### export DB...

Thanks for the reply All that mentioned by the previous poster was already been addressed What happened was the check to share the information registry and datastage server had to be unchecked. as shown below But more importantly the unix person restarted the engines as dsadm instead of the root acc...

Reboot of the client is rulled out as it did not help and we get the same message Also I know it recognizes the user name as it gives a drop down list of projects but when I pick a project it gives me the connect 80011 error saying either username or password is invalid Is this something to do with ...