DSXchange

Can i write multiple conditions in constraint in transformer . example : link2.custid<>'1253' or link2.custid<>'4859' when i write like this the filter is not being applied when i use only one condition like link2.custid<>'1253' then its working fine . What is the mistake in this and can you help me...

Can you help with logic for this scenario . The input records format A B C 3494424 00762111923448 EA 3494424 40762111923446 CS 3494424 70762111923447 PLT And the Output needs to be A EA CS PLT 3494424 00762111923448 40762111923446 70762111923447 Can you help me to achieve this in datastage.

When i am trying to load a table from oracle to teradata using IMMEDIATE as the access method then , i am getting the following error : RDBMS code 350: CLI2: REQOVFLOW(350): Request size exceeds maximum. how can i overcome this particular error . Are there any changes that i need to do for the job ,...

How do i determine what utility is being invoked by TD connector stage .

The options i am using are :
Access Method- Bulk
Write Mode - Insert
Table action : Append

Regarding the primary index : Yes

I have a primary index defined on a column .

Its not unique primary index

I am trying to load from oracle to Teradata: Oracle Connector-->Copy-->TD Connector I have created the target table as multiset and i am loading it , Access Method :Bulk Even tough i have created the table as multiset , it is ignoring the duplicates and not loading them into the target . Error:Numbe...

How do i trim these special characters in datastage , is there any way of doing this in DS , if not how can i handle that while extracting from oracle database .

I am using

seq file >>copy>>TD connector

TD Connector :
Access Method : BULK

when i am trying to load a mainframe file to teradata , i am getting the following error : Teradata_Connector_6,0: RDBMS code 6706: Field CARD_TRACK1 (CC_TeraAdapter::selectLoadErrorTable1, file CC_TeraAdapter.cpp, line 7,430) I am able to load the same file into oracle table but not in TD . the err...