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
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.
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.
"Load failed with exitcode: " + ((Integer)globalMap.get("tTeradataTPTUtility_1_EXIT_VALUE"))
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables