DSXchange

Hi, Is is possible to capture rejected records through reject link of teradata connector if I am using following properties in Teradata connector stage Access Method : Bulk Load Type: Update Error Control (Duplicate Insert Rows): Reject Parallel Synchronization: Yes I have duplicate records in sourc...

Hi Keith,

Thanks for your suggestion. We applied the settings you suggested
NLSPATH=/opt/teradata/client/13.0/tbuild/msg/%N
LANG=en_US

Now TD connector is working.


Again, Thanks for your help
Himani

Here are the Libraries we have in our dsenv file for Teradata Teradata export LIBPATH=/usr/lib/lib_64:/opt/teradata/client/13.0/odbc_64/lib:/opt/teradata/client/13.0/tbuild/lib64:$LIBPATH export TD32_LIBPATH=/opt/teradata/client/13.0/tdicu/lib:/opt/teradata/client/13.0/lib export ODBC_HOME=/opt/tera...

We are using Teradata 13

Thanks,
Himani

Hi, I am trying to use teradata connector stage for bulk operations and getting the following error Teradata_Connector_3,0: RDBMS code 293: PXOPL_Open: dlopen error: Could not load module . System error: No such file or directory SQL statement: INSERT INTO EIS_VMD.TESTCON(first_col,sec_col,third_col...

Dear All,


Is Datastge 8.1 supports Teradata TTU 13.0 or we need to apply fix pack? We are in the process of migrating Teradata to Teradata 13.0 . Your inputs will be highly appreciated.

Thanks,
Himani

Dear ALL, I am using new xml stage in DS 8.5 for processing large amount of data but I 'm facing problem with rejections eg My file structure is <txml> <order_status> <Order>1</Order> <Order_date>2000-10-10</Order_date> <Order_Quantity>2 </Order_Quantity </order_status> <order_status> <Order>2<Order...

Thanks Ray.

It means whether data gets rejected or not, we will get this warning

Hi, I am using reject link in oracle connector stage but I'm getting following warning message even if there is no rejection of records IIS_CONN_ORA_003025- Number of the records rejected on the current node:0 Can you please help me remove this warning message in case no record gets rejected. Thanks...

UPDATE SDKSequences USING DICT VOC SET F1 = 'New_Value' WHERE @ID = 'Sequence_Name';

You can use this in the before/after subroutine
Regards,
Himani