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.