tteradatarow component

Five Stars ami
Five Stars

tteradatarow component

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
Seventeen Stars

Re: tteradatarow component

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.
Five Stars ami
Five Stars

Re: tteradatarow component

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 Smiley Happy
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
Seventeen Stars

Re: tteradatarow component

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.
Five Stars ami
Five Stars

Re: tteradatarow component

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 Smiley Happy
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...Smiley Sad 
regards
Amit
Seventeen Stars

Re: tteradatarow component

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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch