DSXchange

Yes we are using same user to connect to same database in Before SQL and after sql .I also tried to retrieve session if in both "Before SQl" and "After Sql" statement ,and it happened to be different session id i.e Terdata session is disconnected after execution of before sql and...

Hi , We are going through jobs migration from Datastage 8.1 to Datastage 11.3 . But we have observed one issue in Teradata Connecitor stage behavior between these 2 versions : As of current design ,we are using Teradata Connector stage with setting as Access method-Bulk, Transaction Mode-ANSI,Charac...

Yes ,name of the services tier (the one with the 9080 port number) is the same as the name of the engine on which the project exists .

Its using LDAP authentication .Not sure how to get information about your second question .

Hi ,

You can perform a dummy join between these 2 datsets(Create Dummy column in both inputs with static value as 1) and then in Txfm view you can match pattern using substr /index function .

Hi , I am working on Infosphere 8.1 .We have some scheduled jobs running in production daily .But since last few days we are facing particular issue wrt to login to Datstage daily as "Failed to Authenticate current user against selected domain " java.lang.NoClassDefFoundError.com/ascential...

I filtered records with spl. character and tried to load. I get a different error as below:

TERT_test_insert,0: Fatal Error: Fatal: Unable to start MultiLoad process : MultiLoad failed: Check MultiLoad report STG_473_1_ins.rpt for details

I am using sql server as source and yes I see few data's containing spl character like !,$ etc

I wonder whether this is issue for loading to Teradata?

This is my first attempt at using Td connector stage.

Hello All, I am trying to load data from dataset to teradata using teradata connector. I get the below error. Can someone help please. Teradata_Connector_test: Unexpected character found at offset 0 parsing parameter 0 (CC_DBStmtParamParser::getNextToken, file CC_DBStmtParamParser.cpp, line 246) Tha...

Hi , We have created a parallel job using Teradata connector stage as target ,sequential file as source stage . We need to delete few records using presql before loading the data. Delete from table where col1=orchestrate.col1 . But job is aborting with error as "Object 'ORCHESTRATE' does not ex...

Hi

I am working on Datastage 8.1 .Also ,is there any other way of doing it rather than using transform lopp variable ? As we are expecting huge data from source and using transform loop variables will slow down the process .

Hi , I have a equirement to generate number of duplicate records based on a column value .Example is shown below as : Input : id,name,address,col1 1,abc,xyz,5 2,cde,yz,2 Output: As col1 is having value as 5 ,so in output we require 5 nstances of the same record .Similarly for second record ,we need ...

Please let me know if you have information on these xmeta tables .

I have gone through Db2 connectivity guide but couldn't find anything for Windows edition Datastage .

I am able to connect through command prompt .Db2 is installed on same server as of datastage .Do I still need to catalog Db2 ?

Hi, Using below repository tables ,i could retrieve jobname ,stagename and link names. DATASTAGEX_XMETAGEN_DSJOBDEFC2E76D84,DATASTAGEX_XMETAGEN_DSLINKC2E76D84 ,DATASTAGEX_XMETAGEN_DSSTAGEC2E76D84 But I couldn't locate xmeta table storing stage properties ,specifically partioning information . Please...