topic tteradatarow component in Talend Studio

tteradatarow component

Anonymous — Wed, 03 Feb 2016 18:17:16 GMT

Dear All,

I am using tteradata component for
insert into table (value1,value2,) sel * from table
is this a good practice as my project demands insert into sel * from querry in the job
so i have simply put the entire querry inside tteradatarow component of talend and ran it , and its giving me proper output

please let me know if this is doing push down ? as it is faster

Best regards
Amit

Re: tteradatarow component

Anonymous — Wed, 03 Feb 2016 19:27:54 GMT

This is a very common way. But keep in mind, you do not have any control over what happens in this transfer but of course it is the fastest way.

Re: tteradatarow component

Anonymous — Thu, 04 Feb 2016 18:12:18 GMT

jlolling wrote:
This is a very common way. But keep in mind, you do not have any control over what happens in this transfer but of course it is the fastest way.

Thanks for your reply jlolling
so it will be push down right ?
also i am trying to build a TPT job my job looks like
tfileinputdelimined---> tteradatatptutility
please see the screen shot

it said rows inserted but when i check in the table it says 0 rows

if you have any idea please share , that how to load data in the table

thank you
so much
Amit

Re: tteradatarow component

Anonymous — Thu, 04 Feb 2016 18:35:45 GMT

I am not sure but if the teradata tpt util is not installed the component does not fail.
Check if the utility is correctly installed.

Re: tteradatarow component

Anonymous — Thu, 04 Feb 2016 18:46:31 GMT

jlolling wrote:
I am not sure but if the teradata tpt util is not installed the component does not fail.
Check if the utility is correctly installed.

thanks for the reply
yep its install correctly , i rechecked it
may be i am not configuring it correctly ,
if u have any idea do let me know , how shall i overcome this...
regards
Amit

Re: tteradatarow component

Anonymous — Thu, 04 Feb 2016 19:02:51 GMT

The component expects the

tbuild

program in the path. The current version also does not die if something is wrong with the generated script.
Please do following:
Connect a tTerdataTPTUltility with a Run If trigger with a tDie component.

Spend the tDie a meaningful message like (assuming the component unique name is tTeradataTPTUtility_1 - otherwise adjust the number)

"Load failed with exitcode: " + ((Integer)globalMap.get("tTeradataTPTUtility_1_EXIT_VALUE"))

This way you will see if the process it self works correctly. If this works you should check the log files or log tables.