topic Re: Query for each row from input? in Talend Studio

Query for each row from input?

_AnonymousUser — Sat, 16 Nov 2024 13:14:24 GMT

I have a relatively small set of input data. For each row in this input data I need to look for a matching row in a different database. Due to the size of the master database it's not really practical to just select all rows and use a tMap component - I need to run a query for each of the incoming rows.
I thought the tSybaseRow component sounded correct based on the description but when I put in the query, add PreparedStatement parameters, and change the schema accordingly I get a warning and an error ("Warning: Paremeter (Query): schema is different from the query." and Error: "The schema from the input link "row5\" is different from the schema defined in the component").
How can I get this done?

Re: Query for each row from input?

alevy — Mon, 25 Oct 2010 02:02:52 GMT

You should use a standard input component for your lookup but select the "Reload at each row" option in tMap. There are detailed notes in the help about this option.

Re: Query for each row from input?

_AnonymousUser — Mon, 25 Oct 2010 15:29:03 GMT

You should use a standard input component for your lookup but select the "Reload at each row" option in tMap. There are detailed notes in the help about this option.

Thanks!