In my job I fill up a table with an InputFilePositional. After that I want to call a Postgres function which works on the inserted table's rows. My function must be called after the inserting process.
How can I do this whole job in my Job Designs?
My job looks like:
metadata -> tMap_1 -> myTable (PostgresOutput) : IT WORKS.
If I link this way:
metadata -> tMap_1 -> myTable (PostgresOutput) -> tDBRow (which call my function) the job does not works properly.
Would you mind posting your tPostgresRow component setting screenshot on forum? The "call function" doesn't work.
Additionally, there is a global variable like ((Integer)globalMap.get("tDBOutput_1_NB_LINE_INSERTED"))) that counts the number of the inserted data.
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