DSXchange

Hi,
I try this out but when i try to view the data from view data option on the Teradata Connector stage it doesn't give any error but when i run the job it say BigInt is not suportted.

This was configration problem, IBM provide us a patch and its working now

ORCH_WRK_XXXX tables are working tables for Teradata Enterprise stage it use this table to load the load using fastload and then do insert select from this table to the final table, if the job aborts due to any reason these tables will not drop.

There is no simple answer when to use which, but if you want to run the stage in parallel you should use Enterprise stage although Enterrpise stage do have some bugs but that are in certain senarios, Here is how you should to it Enterprise stage: 1) Run in parallel 2) Change the write mode to Upsert...

The trick is to use ORCHESTRATE Keyword when you want to reference the main stream column name in SQL of Teradata Connector. Eg
Select col1,col2 from TableName Where Col1=ORCHESTRATE.ColName

The jobs structure is Teradata Connector - > SeqFile Access Method = Bulk Parallel Synchronization = No (Also tried with Yes but same result) Most the properties are default, Whenever i read or wirte using AccessMethod = Bulk the jobs just hangs it doesn't give any error messgae or any output, so i ...

I have a source table in Teradata(table containing 5 rows) when i read it through Terdata Connector stage(TPT) setting "Access Method = immediate" then it gives the result in few second when i change the "Access Method = bulk" the job doesn't work i wait for it 5-10 min and it do...

Thanks toshea, your post did the trick, the main problem was that we didn't restart ASBAgent in the first place

Could it be that i have TPT 12 installed and Datastage only support TPT 8.1?

1) Great, i will try to do some test. Can you provide some reference document, because i am not able to find details about Lookup Type in the documentation but it do show this sparse option on the canvas.

Yes all the utilities are installed correctly, and for the moment i am just checking if connection could be established or not, but it not working. I have TeradataV12 and Datastage V8, Teradata Enterprise stage Teradata MLOAD stage etc are working fine but not Teradata Connector stage

Hi, I am getting some strange error while try to connect Teradata Connector stage, when i give the connection details and hit the test connection it gives me this message. An exception occurred while trying to receive the response from the handler: An exception was received from the handler: error l...

Can we specify the session per Player and requested session etc options in TPT stage or these are just for Teradata Enterprise stage

Sorry my mistake i didn't check the Section properly, i have posted it on PX Section now. Moderator Please delete this post from here

My Questions are
1) Can Teradata Connector stage be used for sparse lookup? if yes any example would be great.

2) In Server Job can we use Teradata API Stage to do sparse lookup?

3) In Teradata Connector stage what are good practices on the usage of Parallel Synchronization Section.