topic Teradata to Teradata loading in Talend Studio

Teradata to Teradata loading

Anonymous — Wed, 17 Jun 2015 20:38:33 GMT

I have a scenario where i need to load the data from one teradata Table to another table. But i need to perform some transformations like converting the date etc. And I also need to look up on 2 other tables to get certain values. The source table has around 400 million rows and the lookup tables have few hundered thousand rows. Which would be the efficient target component ? (tTeradataOutput takes a very long time do the loading as it generates separate insert statements for each row)

Re: Teradata to Teradata loading

Anonymous — Wed, 17 Jun 2015 22:05:04 GMT

When working on the same database, from table to table, you'd better use the ELT component to make the most of the internal DB engine.
Some documentation to help you use those components:
https://help.talend.com/search/all?query=tELTTeradataInput
https://help.talend.com/search/all?query=tELTTeradataMap
HTH
Elisa

Re: Teradata to Teradata loading

Anonymous — Thu, 18 Jun 2015 16:43:42 GMT

Hello Elisa,
Thanks for the reply. But these 2 tables are in 2 different schemas and the tETLTeradataMap component lets you specify only one database. How do I resolve this?
Thanks,
rhp