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.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.