Hello all,
I would like to migrate all my ETL jobs from pentaho to talend. The job schema is described below.
tMongoDBInput-->row1(Main)-->tSetGlobalVar-->row2(Main)--> tPostgresSQL
In the tSetGlobaVar component I used as key "tbn" and value
row1.id. The Postgres output table name have the following value:
(String)globalMap.get("tbn"). When I run the migration the table name is always
null and I am not able to pass the current value from the global variable.
Below my transformation schema.
Could someone give me a hand of this?
Thank you in advance.
This approach cannot work because the tPostgresqlOutput components setup there SQL statements just before the flow starts - also before you get your table name from tSetGlobalVar. You could use tPostgresqlRow component, this component creates the statements within the flow.
This approach cannot work because the tPostgresqlOutput components setup there SQL statements just before the flow starts - also before you get your table name from tSetGlobalVar. You could use tPostgresqlRow component, this component creates the statements within the flow.
Hello all,
I've used the solution proposed by jlolling. It works perfect. Regards the other solution I could not prepare the ids because are dynamic in each document comping from mongo.
