Fill up a table and execute stored procedure in a job

Seven Stars

Fill up a table and execute stored procedure in a job

Hi,

 

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.

Tags (2)
Moderator

Re: Fill up a table and execute stored procedure in a job

Hello,

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.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.