I need to execute dynamically some sql's. So the flow should be like:
tTeradataInput - tmap - tFileOutputExcel - tTeradataInput2
Basically, tTeradataInput is generating the sql based on some parameters, afterwards with tTeradataInput2 I need to execute the sql generated with tTeradataInput.
Do you have any ideas how I can do it?
Right now I have problems in converting data obtained in tFileOutputExcel (csv) to convert it into a txt file, so afterwards to read it with a tJavaRow and execute the last tTeradataInput2.
Maybe you have a simple solution. Can you please help me with an idea?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences
Take a look at this video about Talend Integration with Databricks