Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I recently learned about the tSQLtemplate component and the first use case that came to my mind was a "DELETE FROM TABLE" query, since we used to delete by extracting the key from a tDBInput und put it into a tDBOutput - Delete component. Hence I figued that this is a good application for a tSQLtemplate, where I can execute the code directly on the database.
However, at this point I was unaware of the TDBRow component, which accomplishes the sames task. Hence, my question is, what problem / use case does the tSQLtemplate solve, which can not be accomplished by a tDBRow component?
Hi
tSQLTemplate performs the SQL statements and data transformations directly within the database engine itself., it is a ELT process.
TDBRow executes SQL statements via JDBC, it is a standard ETL process.
You can find the difference between ETL vs ELT in this page.
Regards
Shong