topic Re: [resolved] How to use SQL query as input to TMap in Talend Studio

[resolved] How to use SQL query as input to TMap

_AnonymousUser — Sat, 16 Nov 2024 13:46:34 GMT

I'm using TIS 3.0.4. I've created a SQL query to join the information from 2 tables and I'd like to feed the results to a tMap. I could use the lookup function, but it loads a couple of million rows from the lookup table and my query works much more quickly.
How do I take the output from the query and use it for further processing? Using it as a tPostgresqlInput doesn't seem to work.

Re: [resolved] How to use SQL query as input to TMap

Anonymous — Thu, 10 Sep 2009 05:08:51 GMT

Hello

How do I take the output from the query and use it for further processing? Using it as a tPostgresqlInput doesn't seem to work.

Why do you say tPostgresqlInput doesn't seem to work? Can you upload a screenshot of your job?
Best regards

shong

Re: [resolved] How to use SQL query as input to TMap

_AnonymousUser — Thu, 10 Sep 2009 14:01:59 GMT

I created a qwuery to pull data from 2 tables: appointments and vehicles. When I pull the query into a job and as a tPostgesqlInput I'm not seeing the fields from the query. It's using the definitions from the first table listed in the Mavmail schema - account_manager_associations.

Re: [resolved] How to use SQL query as input to TMap

_AnonymousUser — Mon, 14 Sep 2009 19:18:56 GMT

Shong - do you have an answer?

Re: [resolved] How to use SQL query as input to TMap

Anonymous — Tue, 15 Sep 2009 04:29:45 GMT

Hello Chyams
You are using a connection from repository, change 'repository' to built-in on propert type and define the schema to map the query column.
Best regardds

shong

Re: [resolved] How to use SQL query as input to TMap

_AnonymousUser — Wed, 16 Sep 2009 16:16:34 GMT

Hi Shong,
Thanks for your help. That fixed my problem.