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.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema