Talend community forum / Query for each row from input?

Andrew J · 2010-10-22 21:57:59

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?

alevy · 2010-10-25 03:02:52

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.

Andrew J · 2010-10-25 16:29:03

alevy wrote:
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!

Announcement

Unanswered posts

#1 2010-10-22 21:57:59

Query for each row from input?

#2 2010-10-25 03:02:52

Re: Query for each row from input?

#3 2010-10-25 16:29:03

Re: Query for each row from input?

alevy wrote:

Board footer