DSXchange

You have 59 columns in the query and you have reference ionly from :1 to :58. I guess you are missing on column.

Badhri ..

Thanks Craig, Couple of Questions ;). 1. Is it not going to be a BIG rework from migrating the mappings to use the Interprocess, Link Partitioner/Collectorfeatures. I heard that they provide you with great performance benifits ??? 2. What are the notable advantages of using Oracle 9i plug in over 8i...

Greetings, We are currently using DataStage 5.2 on Sun Solaris. We are planning to migrate to DataStage 6 next year Feb. 1. What would be the amount of work involved in the migration process. 2. Currently we are using ORAOCI8 to connect to the oracle 9i database. And since we have Oracle 9i plugin w...

Greetings, We are using DataStage 5.2 on Unix and this doesn't have the Oracle 9i Plugin and we also have DataStage 6 which has but the Oracle 9i Plugin but couldn't use that bcoz of the lack of NLS Support. Now, what are disadvantages of using ORAOCI8 plugin to connect Oracle 9i database. Please le...

Greetings,

I'm in the process of preparing the DataStage standards to be followed for an upcoming project. Please help me with your thoughts or let me know whether these is any Standard document ??

Thanks in Advance.

Badhri ...
www.cognizant.com

Greetings, We are having DataStage 4.2 in our Sun Solaris 2.7 box. We want to upgrade this to DataStage 6.0. Can I have a fresh installation of DataStage in a different folder hierarchy without disturbing the existing version in that Unix box. Due to short of resoruce I want to do this in the Develo...

Greetings,

Does DataStage supports Address Cleansing/Parsing Functionalities. I am looking for functioanlities like Address De-duplication as available in the Data Cleansing.

I find that that new ETL tools also have the Data Cleansing coupled to them.

Thanks in Advance.

Badhri ...

Thanks for the inputs,

I will compare the Access tables and the Oracle tables. We have NLS enabled. Is their anything to be taken care for this ????.

Thanks,
Badhri ...

Greetings,

We run Datastage 4.2 in Unix.

I used the reporting assistant to update the metadata in to the Oracle Database. But when I try doing this Datastage throws an Oracle error message "TOO MANY VALUES".

Please help me with your inputs.

Thanks in Advance,
Badhri ...

Hi, We upgraded our project from DS4.0 to DS4.2. We have a job which has two ORAOCI8 plug-ins with a transformer in the middle to do the one-to-one mapping. There was a column in the source table of decimal datatype and the length was specified as 38 in DS4.0 and the datatype in the Oracle database ...

Hi, We upgraded our project from DS4.0 to DS4.2. We have a job which has two ORAOCI8 plug-ins with a transformer in the middle to do the one-to-one mapping. There was a column in the source table of decimal datatype and the length was specified as 38 in DS4.0 and the datatype in the Oracle database ...

Greetings, We upgraded from 4 to 4.2 and we have a job that has a source and a target oracle oraoci8 plugins with a one-to-one mapping between them. When I run the job I get the below mentioned oracle error in the source plug-in. ORA-01406 fetched column value was truncated Please help. Badhri .. P....