topic Re: TDBSP oracle with parameters Input in Talend Studio

TDBSP oracle with parameters Input

Anonymous — Sat, 16 Nov 2024 04:39:05 GMT

Dear All,

can you help me how to put parameters for the procedure DO_ETL:

this is my procudere DO_ETL with parameter In V_NUMDATE:

this is tDBSP oracle: i want input parameter get from server file or some table in the DB server.

regards,

fdenis — Wed, 18 Sep 2019 08:11:42 GMT

to add parameters click on the green "+" button on the bottom.

Anonymous — Thu, 19 Sep 2019 03:14:00 GMT

thank Francois Denis,

i know that, but How can I get the parameter values from the text file and put in the TBSP oracle component?

fdenis — Thu, 19 Sep 2019 09:04:09 GMT

read file first.

use tmap to extract your params

use column names to select Schema Colune name.