DSXchange

Hi,

I found that a 3rd party ODBC driver is available to connect to Cassandra -- SIMBA and DATAFLEX.

Any idea on this please?

http://www.simba.com/build-big-data-dat ... 6wodhC8nvw

Hi,

Has anyone tried connecting Cassandra Database in Datastage 8.0.1.

If so what is the procedure?

Could anyone let me know about this.

http://www.tek-tips.com/viewthread.cfm?qid=714455&page=21 Thanks for your response Craig. So please check if got it correctly:- In the where clause in update script(generated by MLOAD stage),it is a must to include Primary Index(on teradata table) with equity condition and this primary index sh...

Hi, We are having Oracle Connector as Source and Teradata MLOAD stage as target stage and in between,a transformer has been used in one of parallel jobs.When I select primary Index as key in MLOAD stage,the job works fine(No error but some records get dropped due to duplicates in Index value).Howeve...

Hi, We are not able to see any data types in any of the stages (for ex: Oracle Connector, Teradata Multiload). Till yesterday it was fine but all of a sudden we are not able to see those today. Could any one please help us in this regard? We are not able to do any development work due to this problem.

Hi,

We are facing some hang issues with ODBC stage. We have chosen the upsert option in this stage. But, the job goes to a hang state with this option being selected. We need the upsert option to be selected in the stage.

Could any one please let us know the resolution for this?

Thanks,
Siva

Hi, We are facing with the following error while running a parallel job in datastage 8.1: "Resource bundle corresponding to message key DSTAGE-TODC-00053 not found! Check that DSHOME or APT_RESPATH is set". We verified that these parameters are set to appropriate values. Our job is compris...

Hi, Here are all the options that we had tried till now: Our Datastage server is on Win2k3. While logging into Admin Client using admin ID, we are unable to perform lock operations. We are encountering with the following error while executing some commands: (i) unlock user usernumber all (ii) unlock...

Yes, we confirmed that the job was not opened in the Director.

Also, we do a check that the particular job is not openend in any other else's machine.

In Designer, right click on the job and delete

Hi, We are facing with a weird problem in Datastage 8.1. We tried to delete a job but was not successful encountering with the error "Unable to delete the job". We tried several times and left as it was as we are unable to do so. Later on, we found that the particular job was missing from ...

Hi, Can any please let me know the procedure for making the PARAMETERS set value as PROJECT Defined? I have created a parameter set, and am using this in my jobs. While running any job, a prompt occurs for entering the value. So, i would like to know if there is a way to make the parameter set as PR...

Hi,

I found in one of the post that to run the query "release mload <tablename>".

But this didnt helped us much.

Thanks,
Siva

Hi, We have been facing an issue with Mload stage in our parallel jobs. Whenever the job fails, mload process hangs up and is not releasing for quite some time. Also, this process is occupying the most of the CPU making the server very slow. As a result of this, other people are not able to run thei...

Hi,

We are using Teradata Enterprise Stage in our job, and are facing the following error while running the job:

"TeraSync: waitOnState(2) timed out"

Could any one please help us in resolving this error.

Thanks,
Siva